Windows().Activate vs Workbooks().Activate

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.
 
Thank you.
--
Gary's Student


Tom Ogilvy said:
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.
Click to expand...
 
With a worksheet in book2.xls active, use window|New window.

Then try the "windows("book2.xls").activate" line.
 
Dave raises a good point about a workbook being able to have multiple windows.

I personally always use workbooks rather than windows.
 
Back
Top