Try this :
Add 1 Command Button to your form.
Add 1 reference to Microsoft Excel 12.0 Object Library Project -> References -> mark the Microsoft Excel 12.0 Object Library
Private Sub Command1_Click()
Dim xlApp As Excel.Application
Dim xlWB As Excel.Workbook
Dim xlWS As Excel.Worksheet
Set xlApp = New Excel.Application
Set xlWB = xlApp.Workbooks.Add
Set xlWS = xlWB.Worksheets.Add
' This following lines will fill the cell (2,2) with the text "hello",
' and will fill the cell (1,3) with the text "World"
xlWS.Cells(2, 2).Value = "hello"
xlWS.Cells(1, 3).Value = "World"
' The following line saves the spreadsheet to "c:\mysheet.xls" file.
' Free memory
Set xlWS = Nothing
Set xlWB = Nothing
Set xlApp = Nothing
Need some help with this Array. I am trying to get the sum of the even numbers and the sum of the odd numbers using a for each loop. I know the answers to what I am trying to achive are sum of even = 84 and the sum of ...
I have a 2d matrix with dimension (3, n) called A, I want to calculate the normalization and cross product of two arrays (b,z) (see the code please) for each column (for the first column, then the second one and so on).
the function that I created to find the ...