You could have a function in the workbook that returns the value of that
variable, then call that function using application.Run
Otherwise, you would need to create a reference to the workbook containing
the public variable.
--
Regards,
Tom Ogilvy
MWE wrote in message
...
VBA provides ways to declare variables that are "known":
within a given procedure
to all procedures in a module
to all procedures in a project
Is there a way to declare variables that are known to all open
projects?
Thanks
---
Message posted from http://www.ExcelForum.com/