Posted to microsoft.public.excel.programming

Tim Williams[_4_] Tim Williams[_4_] is offline

external usenet poster

Posts: 114

Problems with Activeworkbook.Close

On Feb 2, 9:18*pm, Terry wrote:
On Feb 2, 8:41*pm, Tim Williams wrote:

Why use workbook_activate rather than workbook_open ?

Not sure that would fix your problem but worth a try...

Tim

Actually, it is on open and not activate.

Wherever it is, it only exhibits this bizarre behavior if there is at
least one other workbook open.

Hard to suggest anything without seeing actual code.

Tim

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
ActiveWorkbook.close problem	Spike	Excel Programming	6	May 25th 09 02:58 PM
In Before Close Sub ActiveWorkBook.Close(False) repeat procedure	[email protected]	Excel Programming	5	September 26th 06 03:11 PM
ActiveWorkbook.Close	dallas	Excel Programming	0	November 3rd 04 06:27 PM
ActiveWorkbook.Close	dallas	Excel Programming	2	November 3rd 04 05:56 PM
ActiveWorkbook.Close	Matthew[_9_]	Excel Programming	4	November 13th 03 02:48 AM

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

About Us

"It's about Microsoft Excel"

Menu

About Us