Save & Restore a column

K

kirkm

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
 
M

Mark Ivey

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
 
K

kirkm

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

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?
Click to expand...

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
 
M

Mark Ivey

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

What about using a hidden spreadsheet?

Mark
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Advice on With-End With 3
Macro for Creating Word Document!! 5
Sorting a column 2
Advice on multiple macros, same code just a different column 9
import text 1
wildly varying execution speeds - is it the code? 3
any ideas why execution speed varies? 5
Speeding up the importing of data from file 5

Top