Share global variable between workbooks

X

XP

Using Office 2007 and Win XP;

I need to share a global variable between workbooks in the same instance of
XL;
The variable is loaded in a standard code module of Book-A; in Book-B, there
is code in the "ThisWorkbook" module that needs to retrieve the contents of
the variable.

1) Is this possible?
2) If possible, can someone please explain or better yet, post a generic
example illustrating how to do this?

Thanks much in advance for your assistance!
 
D

dbKemp

Using Office 2007 and Win XP;

I need to share a global variable between workbooks in the same instance of
XL;
The variable is loaded in a standard code module of Book-A; in Book-B, there
is code in the "ThisWorkbook" module that needs to retrieve the contents of
the variable.

1) Is this possible?
2) If possible, can someone please explain or better yet, post a generic
example illustrating how to do this?

Thanks much in advance for your assistance!
Click to expand...

It is possible.
Declare the variable in Book-A as module level Public variable.
Then have Book-B reference Book-A. You should give Book-A project
some name other than VBAProject. Then go to Tools/References and
check that project. Then you can refer to the variable using the
ProjectName.PublicVariable syntax.

So if you:
named the project for Book-A => MyData
named the Book-A public variable => MyVariable
then after referencing MyData from Book-B you could retrieve
MyVariable like this x = MyData.MyVariable
 
Top