M
Minitman
Greetings,
I have 2 workbooks open and need to open a 3rd.
The 1st workbook needs to declare the names of all 3 workbooks as 3
variables (eg: wb1, wb2 and wb3) and do this before the last 2 are
opened.
Is this possible?
I looked at Public and Global declarations in MS help and came away
more confused then before.
JLGWhiz suggested I check out Chip Pearson's web site:
http://www.cpearson.com/excel/TrulyGlobalVariables.htm
to answer my question about global variables. That site has a lot of
very interesting things to say about global variables. However, I
noticed that the global variables, in the code they were talking
about, were limited to long numbers. To quote from the article -
"Note that these variables may contain only Long type numeric data."
This raised the question, don't my 3 variables have to be declared as
workbooks and not long numbers?
Can anyone clarify this question and maybe give some examples as to
how this can be accomplished?
Any help will be appreciated.
-Minitman
I have 2 workbooks open and need to open a 3rd.
The 1st workbook needs to declare the names of all 3 workbooks as 3
variables (eg: wb1, wb2 and wb3) and do this before the last 2 are
opened.
Is this possible?
I looked at Public and Global declarations in MS help and came away
more confused then before.
JLGWhiz suggested I check out Chip Pearson's web site:
http://www.cpearson.com/excel/TrulyGlobalVariables.htm
to answer my question about global variables. That site has a lot of
very interesting things to say about global variables. However, I
noticed that the global variables, in the code they were talking
about, were limited to long numbers. To quote from the article -
"Note that these variables may contain only Long type numeric data."
This raised the question, don't my 3 variables have to be declared as
workbooks and not long numbers?
Can anyone clarify this question and maybe give some examples as to
how this can be accomplished?
Any help will be appreciated.
-Minitman