Passing Arguments

[Fire_Chief]

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

 

[erik.van.geit]

This is not really the best answer, but a temporary solution.
Put your YES in a cell of your workbook #1.

Excel won't "forget" that !

regards,
Erik

 

[Joe4]

I don't know that you can pass an argument from one Workbook to another. What I would do is put all my VB code in one of the workbooks because you CAN pass arguments from one macro to another in the same Workbook and you CAN run VBA code located in one workbook on another open Workbook.