What is the best way to make an archive of data

V

VILLABILLA

Hi,

I have a workbook that produces print outs, these print outs are no
archived on paper format, an additional archive should be made o
computer format.

I am looking what would be the best way to make a backup of this data
it can be in text format, because a simplified overview in text woul
be sufficient to store as backup.

I tried making a macro that copied data into a word file but it didn'
work at all.

Saving it into Excel's 65000 rows is not an option because they woul
be filled in a few weeks...

I guess I need some ideas from someone that is a bit more handy than m
with these things ...

thanks in advance..
 
B

Bob Phillips

Take a look at the OpenTextFile method in VBA help, it may be what you want.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 

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

best way to archive records? 3
Archive Email Files Problem 0
What is the best way to do this 1
Best way to place text data into a formated Template? 1
what is the best way to pull in external data from SQL table 3
What is the best way to organize a data in order to PRINT specific 4
Conditional Formatting according to the date the data is entered 1
Trying to make both averages AND sums of one spreadsheet of data 1

Top