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.


--
Bruce001
------------------------------------------------------------------------
Bruce001's Profile: http://www.excelforum.com/member.php...o&userid=26630
View this thread: http://www.excelforum.com/showthread...hreadid=483161

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/200404050...eio/fileio.asp
File Access with Visual Basic® for Applications

--
Regards,
Tom Ogilvy




"Bruce001" wrote in
message ...

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.


--
Bruce001
------------------------------------------------------------------------
Bruce001's Profile:
http://www.excelforum.com/member.php...o&userid=26630
View this thread: http://www.excelforum.com/showthread...hreadid=483161

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 Wrote:
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://tinyurl.com/dghhf
File Access with Visual Basic® for Applications

--
Regards,
Tom Ogilvy


--
Bruce001
------------------------------------------------------------------------
Bruce001's Profile: http://www.excelforum.com/member.php...o&userid=26630
View this thread: http://www.excelforum.com/showthread...hreadid=483161

Here are some other sources:


http://support.microsoft.com/default...b;en-us;151262
Working with Sequential Access Files

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

--
Regards,
Tom Ogilvy

"Bruce001" wrote in
message ...

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 Wrote:
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://tinyurl.com/dghhf
File Access with Visual Basic® for Applications

--
Regards,
Tom Ogilvy


--
Bruce001
------------------------------------------------------------------------
Bruce001's Profile:
http://www.excelforum.com/member.php...o&userid=26630
View this thread: http://www.excelforum.com/showthread...hreadid=483161