Refer to Public Variable from Another Workbook
Figured it out:
Windows("wb1.xls").Activate
With Selection
Processingon = 1
End With
"Mike H." wrote:
I am workbook Other.xls, running a macro in module2. I wish to refer to a
public variable in wb1.xls, module1 called pubvar. I am doing things in the
wb1.xls file with the macro and need to set the value of a public variable
there so I can turn off some error checking that the file is performing. How
is this done?`
|