Posted to microsoft.public.excel.programming

Squid[_2_] Squid[_2_] is offline

external usenet poster

Posts: 17

Checking for open workbook...

I want to add some code to a workbook_BeforeClose event.
For example sake, lets call this Workbook1. I want to
sort the contents of Workbook1!Sheet1 only if Workbook2
is not open.

How can I test to see if another Workbook is open?

Thanks
Mike

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
Checking to see if a Workbook is Open	Todd Huttenstine[_3_]	Excel Programming	4	December 25th 03 11:55 PM
Checking if workbook is open	Jesse[_4_]	Excel Programming	6	December 11th 03 11:17 PM
Checking if workbook open (where path is unknown)	[email protected]	Excel Programming	0	September 4th 03 11:13 PM
Checking for Open Workbook	sbharbour	Excel Programming	6	August 28th 03 11:42 PM
checking if workbook is open before accessing	David Goodall	Excel Programming	1	August 22nd 03 08:43 PM

All times are GMT +1. The time now is 07:33 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us