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

--
Regards,
Tom Ogilvy




"Bruce001" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[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

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

--
Regards,
Tom Ogilvy

[Tom Ogilvy]

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" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>