View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Mike H. Mike H. is offline
external usenet poster
 
Posts: 471
Default 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?`