| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Windows().Activate vs Workbooks().Activate
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. -- Regards, Tom Ogilvy "Gary''s Student" wrote: 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Windows().Activate vs Workbooks().Activate
Thank you.
-- Gary's Student "Tom Ogilvy" wrote: 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. -- Regards, Tom Ogilvy "Gary''s Student" wrote: 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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Windows().Activate vs Workbooks().Activate
With a worksheet in book2.xls active, use window|New window.
Then try the "windows("book2.xls").activate" line. Gary''s Student wrote: 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 -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Windows().Activate vs Workbooks().Activate
Dave raises a good point about a workbook being able to have multiple windows.
I personally always use workbooks rather than windows. -- Regards, Tom Ogilvy "Gary''s Student" wrote: Thank you. -- Gary's Student "Tom Ogilvy" wrote: 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. -- Regards, Tom Ogilvy "Gary''s Student" wrote: 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Windows.Activate | Excel Programming | |||
| Windows().activate generating obj reqd msg why? | Excel Programming | |||
| Workbook.Activate / Window.Activate problem | Excel Programming | |||
| Reference to a variable in windows(???).Activate | Excel Programming | |||
| using array with Windows().activate | Excel Programming | |||
Linear Mode
