Posted to microsoft.public.excel.programming

Gary''s Student Gary''s Student is offline

external usenet poster

Posts: 11,058

Windows().Activate vs Workbooks().Activate

If I have tow workbooks open, say Book1 and Book2, I can usually navagate
from Book1 to Book2 with Workbooks("Book2").Activate. Once in a while I need
to do a Windows("Book2.xls").Activate.

What is the difference between the two and which should be used in general?

--
Gary's Student

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
Windows.Activate	Steph	Excel Programming	3	August 17th 06 10:18 PM
Windows().activate generating obj reqd msg why?	Chet	Excel Programming	2	July 26th 06 09:47 PM
Workbook.Activate / Window.Activate problem	Tim[_44_]	Excel Programming	3	February 3rd 06 11:38 PM
Reference to a variable in windows(???).Activate	John Baker	Excel Programming	7	July 13th 04 02:04 PM
using array with Windows().activate	NikkoW	Excel Programming	1	May 4th 04 03:15 AM

All times are GMT +1. The time now is 11:47 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us