| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Switch to Excel workbook in a separate instance of Excel
Using Excel 2003...
I'm trying to get Excel to switch to another workbook that is open in a separate instance of Excel. ActiveWindow.ActivateNext works fine to switch between workbooks open in the same instance of Excel, but won't work for this purpose. I was looking at using the Index function to cycle through the different instances, but can't get the syntax right. Any help is appreciated. Thanks. -- HTH Don''''t forget to rate the post if it was helpful! Please reply to newsgroup only, so that others may benefit as well. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Switch to Excel workbook in a separate instance of Excel
Maybe... http://support.microsoft.com/kb/302460 "...Automation Help File..." -- Jim Cone Portland, Oregon USA "Maverick" wrote in message Using Excel 2003... I'm trying to get Excel to switch to another workbook that is open in a separate instance of Excel. ActiveWindow.ActivateNext works fine to switch between workbooks open in the same instance of Excel, but won't work for this purpose. I was looking at using the Index function to cycle through the different instances, but can't get the syntax right. Any help is appreciated. Thanks. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Switch to Excel workbook in a separate instance of Excel
I'm using Excel 2003, not XP. Thanks for trying.
-- HTH Don''''t forget to rate the post if it was helpful! Please reply to newsgroup only, so that others may benefit as well. "Jim Cone" wrote: Maybe... http://support.microsoft.com/kb/302460 "...Automation Help File..." -- Jim Cone Portland, Oregon USA "Maverick" wrote in message Using Excel 2003... I'm trying to get Excel to switch to another workbook that is open in a separate instance of Excel. ActiveWindow.ActivateNext works fine to switch between workbooks open in the same instance of Excel, but won't work for this purpose. I was looking at using the Index function to cycle through the different instances, but can't get the syntax right. Any help is appreciated. Thanks. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Switch to Excel workbook in a separate instance of Excel
"You can lead a horse to water, but..." "Maverick" wrote in message I'm using Excel 2003, not XP. Thanks for trying. "Jim Cone" wrote: Maybe... http://support.microsoft.com/kb/302460 "...Automation Help File..." -- Jim Cone Portland, Oregon USA "Maverick" wrote in message Using Excel 2003... I'm trying to get Excel to switch to another workbook that is open in a separate instance of Excel. ActiveWindow.ActivateNext works fine to switch between workbooks open in the same instance of Excel, but won't work for this purpose. I was looking at using the Index function to cycle through the different instances, but can't get the syntax right. Any help is appreciated. Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I open a new Excel document in a separate instance of Excel? | Excel Discussion (Misc queries) | |||
| open spreadsheets into separate excel instance | Excel Discussion (Misc queries) | |||
| Separate Window/Instance Per Excel File | Excel Discussion (Misc queries) | |||
| open excel in a separate instance | Excel Discussion (Misc queries) | |||
| How to create separate instance of Add-in for new Workbook? | Excel Programming | |||
Hybrid Mode
