Posted to microsoft.public.excel.programming

external usenet poster

Posts: 471

Refer to Public Variable from Another Workbook

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?`

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Public Variable	Marvin	Excel Programming	1	March 29th 07 09:50 PM
Public variable	Eric[_35_]	Excel Programming	7	March 18th 07 06:54 AM
Public Const to refer to a range name	TimT	Excel Programming	1	August 23rd 06 08:14 PM
Public variable	Jack	New Users to Excel	4	March 18th 06 09:35 PM
public variable	marwan hefnawy	Excel Programming	1	September 5th 03 08:54 AM

All times are GMT +1. The time now is 08:56 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us