Bravurian17
New Member
- Joined
- Apr 16, 2009
- Messages
- 34
I have a bunch of Variables that I have in one workbook and I was wondering if I could declare it for the whole application rather than just the project.
Example for Main Workbook:
Then on any other Workbook:
This is only a very basic example of what I want to accomplish.
The number of other Workbooks is unknown.
Thank You
Example for Main Workbook:
Code:
Option Explicit
Public Shop, Shift, Name as String
Sub Add
Shop = "Engine"
Shift = "Days"
Name = "Ted"
End Sub
Code:
Sub GetShop
Msgbox Shop
End Sub
Sub GetShift
Msgbox Shift
End Sub
Sub GetName
Msgbox Name
End Sub
The number of other Workbooks is unknown.
Thank You