saving 2 dimensional arrays

[rburton]

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?

[nswan]

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