I've a requirement to save (and restore) an Excel column externally
The rows are 2 to the last one.

I would do this by using a For Next loop which writes each cell
content to a text file, and reads them back the same way.

However there may be a more sophisticated method using ranges
(which I barely understand), with a built in import/export routine?

If anyone has a better method than my loop/text file, would you
let me see it ?

Thanks - Kirk

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

I believe it would have to be a Global Array to save the data for any
extended period of time, but I am not totally sure.

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

Mark Ivey




"kirkm" wrote in message
...

I've a requirement to save (and restore) an Excel column externally
The rows are 2 to the last one.

I would do this by using a For Next loop which writes each cell
content to a text file, and reads them back the same way.

However there may be a more sophisticated method using ranges
(which I barely understand), with a built in import/export routine?

If anyone has a better method than my loop/text file, would you
let me see it ?

Thanks - Kirk

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

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

I meant a hidden worksheet.

Mark Ivey



"Mark Ivey" wrote in message
...
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