Ahhh... in that case an array would not work.

What about using a hidden spreadsheet?

Mark

"kirkm" wrote in message
...
On Fri, 11 Apr 2008 20:27:59 -0500, "Mark Ivey"
wrote:

Can you save it to an array and then bring it back in?

Yes, I can't see why not. Would that be an advantage ?

How long between the save and the restore? Are there a lot of changes
going
on between the save and restore?

The times between would depend on when the xls was upgraded to a new
version. No changes should occur that aren't saved, I plan to 'export'
the data as the workbook closes.

Cheers - Kirk