Windows().Activate vs Workbooks().Activate

[Gary''s Student]

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?

 

[Tom Ogilvy]

You should always use Book2.xls. It should always work. The success
enjoyed when not using the extension is dependent on a windows level setting
- folders setting to hide known extensions.

whether you use windows or workbooks I doubt makes a difference.

 

[Gary''s Student]

Thank you.
--
Gary's Student

You should always use Book2.xls. It should always work. The success
enjoyed when not using the extension is dependent on a windows level setting
- folders setting to hide known extensions.

whether you use windows or workbooks I doubt makes a difference.

 

[Dave Peterson]

With a worksheet in book2.xls active, use window|New window.

Then try the "windows("book2.xls").activate" line.

 

[Tom Ogilvy]

Dave raises a good point about a workbook being able to have multiple windows.

I personally always use workbooks rather than windows.