Saving an array

[filo666]

Hi, I have a program that has been runing for 6 hrs and has colected 12000
elements on a array, it will take like other 6 hrs so to finish, is there is
a way so to save the array ( to pause the program and to put some code on it)
so to save the obtained array???
thanks

 

[alborg]

Hi Filo:

You need to save the data obtained by your array, which can be done by
several means- a Word table, an Access temporary table, or an Excel workbook.
An example of the latter can be seen here-
http://www.exceltip.com/st/Array_variables_using_VBA_in_Microsoft_Excel/509.html

If you wish to go further, you might wish to post your array code.

Cheers,
Al