I need some help in understanding the use of the PUBLIC statement.

VBA Help for PUBLIC states that "Variables declared using the Public
statement are available to all procedures in all modules in all
applications...". I have taken that to mean that if I am running VBA in one
spreadsheet, and it opens a second spreadsheet, the PUBLIC variables in the
first code are available to the code in the second application. But that
doesn't seem to be the case. Is this an incorrect interpretation, or am I
not doing something right?

If this is not the way PUBLIC works, is there some other way for a file
(FILE B) opened by another file (FILE A) to use variables defined in the
original file (FILE A)?

If nothing else, is there a way for FILE A to write a value to a particular
memory location, and then have FILE B read from that memory location?
--
Bill @ UAMS