I am trying to seta variable in one workbook, to then pass it to another workbook.
In workbook A, I have this code:
Please Login or Register to view this content.
The last line runs a macro called Queries_3 in workbook B.
I am trying to pass a global variable, from workbook A to workbook B, but have exhausted my googling.
Any help would be really really great!.
Thanks
Hi,
Does Queries_3 take an argument, or does it need to refer to a variable in workbook B? If it's the latter, you would have to either make the variable a member of the ThisWorkbook module of workbook B, or add a routine to workbook B that takes an argument and assigns it to the variable in the other workbook.
Don
Please remember to mark your thread 'Solved' when appropriate.
Hi xlnitwit
At the moment, it does not have an argument, (If workbook B (abc) = variable then), I assume that's what you meant.
How would I go about doing this?
If you amend Queries_3 to take an argument, you can simply pass the value directly in the Run statement, rather than relying on public variables.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks