VBA Macro - save / restore variables when closing / opening Excel?

[danmeeks]

I have an application that I have been nursing for a few years. One thing that I need to do is have it save all of the variables when I close Excel, so that when I open it again I can continue editing.
Is there a straight-forward way to do this? I am hoping for a dump to a file that can be reloaded later using a button / macro.
Thanks
dan

[TMS]

The easiest way would be to store the variables/parameters in a hidden worksheet in the workbook. No chance of them being lost or corrupted in an external file.

[ByteMarks]

For a file dump option you could save the variables to an ini file.

Put this in a module

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.