Fire_Chief
Well-known Member
- Joined
- Jun 21, 2003
- Messages
- 690
- Office Version
- 365
- Platform
- Windows
I am having a terrible time trying to pass an argument from one workboork to another workbook.
I am using the variable (CLOSE_IT) as a string. I want it to hold the value "YES"
In workbook #1 I assign the value "YES" in a sub that opens workbook # 2 but when I run a sub in workbook 2 the value is empty.
I have tried every way i know and everything I read, but it won't work.
I have tried putting the variable in the parenthess of the first sub..........Sub mysub(CLOSE_IT) but excel won't even accept this and the sub will not run when I do this.
I have also dimensioned CLOSE_IT as Public.
Please help.
An example would really help.
Thank You Marty
D1A@aol.com
I am using the variable (CLOSE_IT) as a string. I want it to hold the value "YES"
In workbook #1 I assign the value "YES" in a sub that opens workbook # 2 but when I run a sub in workbook 2 the value is empty.
I have tried every way i know and everything I read, but it won't work.
I have tried putting the variable in the parenthess of the first sub..........Sub mysub(CLOSE_IT) but excel won't even accept this and the sub will not run when I do this.
I have also dimensioned CLOSE_IT as Public.
Please help.
An example would really help.
Thank You Marty
D1A@aol.com