Greetings,
I have a VB program in Excel, and I need to store the value of two variables between runs of the macros in the workbook. The workbook will be closed and open at various times.
Currently, I have the VB program create a sheet called "Data" then hide it. I then place these values in cells of worksheet "Data" then recall when needed. I was just wondering if there was a better method.
Thank you,
You could make the Data sheet xlVeryHidden so it's less easy to access.
Or you could write the variables to a text file.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
There are few ways to do it. But what you are using is probably the easiest.
1. If you need to access these variables without opening workbook. You could store it in text file.
Ex:
2. You could write variables to registry... but personally I don't like using registry for this purpose. Check link for how to read/write to registry.
Please Login or Register to view this content.
https://vba-corner.livejournal.com/3054.html
?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
― Robert A. Heinlein
Please Login or Register to view this content.
Ben Van Johnson
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks