Saving Reloading

[Bruce001]

I have a workbook with about 35 worksheets. I have input fields spread
throughout these sheets of about 100 fields. THe workbook is becoming
too large to save each instance values change and need to be recalled.
I created a new sheet that has links to all the inputs.

What I would like to do is save this one sheet and the values (not
links) and be able to reload it using a macro. All the values can be
plain text. If saved in an excel format, I would also like to change
the sheet name so when it is reloaded, I don't have a problem with the
original sheet.

Any help would be greatly appreciated.

 

[Tom Ogilvy]

You explanation isn't real clear, but

Perhaps you would write the values to a text file, then read it in and
repopulate your values:

http://web.archive.org/web/20040405...scid=/support/excel/content/fileio/fileio.asp
File Access with Visual Basic® for Applications

 

[Bruce001]

That is what I would like to do. But I am getting an error trying to
open your link. I'll just have to keep searching.

Thanks,
Bruce

 

[Tom Ogilvy]

Here are some other sources:


http://support.microsoft.com/default.aspx?scid=kb;en-us;151262
Working with Sequential Access Files

http://www.applecore99.com/gen/gen029.asp