I would like to put a two dimensional array into a holder through automation. Can I put it into an Excel spreadsheet and what code should I use?
Printable View
I would like to put a two dimensional array into a holder through automation. Can I put it into an Excel spreadsheet and what code should I use?
dim numbers(10,10) as integer
dim count1 as integer
dim count2 as integer
dim XL1 as new excel.application
XL1.workbooks.open("c:\myspreadsheet.xls")
for count1 = 1 to 10 do
for count2 = 1 to 10 do
XL1.Cells(count1,count2) = numbers(count1,count2)
next count2
next count1
XL1.quit
set XL1 = Nothing
obviously the numbers array has to have values in it to start with!
Think that should do it.
Nick