Declare Multiple Variables for any Open Workbooks

In general it is good development practice to avoid global variables. That said, I don't believe variables in one workbook (project) are accessible in another. You could write a function/sub (or multiple functions/subs) that share/update the value of these variables. If you do that, these functions/subs will behave, at a conceptual level very much like properties of the workbook object.

You could also explictly do the same. For an article I authored for MSDN some time ago, see
How to use a class (object) from outside of the VBA project in which it is declared
http://support.microsoft.com/kb/555159

tusharm,

That might be a lot more than what I was hoping for. What was the Global thing you wanted to avoid?

Thanks for the quick response
B-17

Hi Bravurian17

I don't see why I'd use a public variable in one workbook to be used by another, an approach like Tushar suggests is preferable. It is possible, however, to do it. You just have to reference the workbook with the public declarations.

In your example, assuming you have saved the workbooks as main.xlsb and other.xlsb,

- select any module in the main.xlsb project
- change the name of the project in Tools->VBA Project properties to VBAProject001
- select any module in the other.xlsb project
- in Tools->References check the reference to VBAProject001

Now try running Main() and then any of the GetShop, GetShift or GetName.

What do you mean by:

Now try running Main() and then any of the GetShop, GetShift or GetName.

Click to expand...

I have been playing with VBA for over a year now; I'm self taught, so I learn new things that I wish I knew months ago. Could you give an example, of it used in a procedure, of the "Get" property and other ways I could use it.

Thank You,
B-17

Problem solved! Thanks for all who replied and made me use my wording better on Google.

For those who want to know I found my solution here:

http://www.pcreview.co.uk/forums/thread-1644166.php

Thanks Again,

B-17

That's exactly what PGC suggested -- and is, essentially, a simpler version of what I suggested.

Bravurian17 said:

Problem solved! Thanks for all who replied and made me use my wording better on Google.

For those who want to know I found my solution here:

http://www.pcreview.co.uk/forums/thread-1644166.php

Thanks Again,

B-17

Click to expand...

ohhh, it was a lot simpler. well you did give me the idea to search for global variables, so you still get credit.