how to keep workbook name active

[grantj]

I created a macro that permits a user to open an existing workbook (say VersionOne) and copy their data into a new version (versionTwo).

Please Login or Register  to view this content.

The macro is becoming quite large and I want to create several additional macros to help me keep track of each worksheet being copied. Is there a way for the name "VersionOne" to stay active from one marco to the next? I don't want the user to keep opening up the same workbook. Thanks

[rylo]

Hi

Some options..

1) Create a global variable that is valid across all the macros in the project
2) Create a storage point on say the spreadsheet containing the macro
3) Pass the current name as an argument to the subsequent macros
4) Make the variable static
5) Put the variable value into a text file
6) Use Savesetting / Getsetting to store / retrieve values from the registry.....


HTH

rylo

[mudraker]

grantj

Please take a couple of minutes and read ALL theForum Rules then wrap your VBA code (Rule 3)