Share global variable between workbooks

[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!

 

[Gary''s Student]

If you have a set of workbooks that are all open at the same time, just
assign some cell in one of the workbooks to hold the variable. This way VBA
can retrieve/modify the variable just like any other cell.

An alternative is to assign some registry key to hold the variable and use
savesetting/getsetting

 

[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!

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