Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
GetActiveObject("Excel.Application") for multiple instances of Exc
Hi,
I'm trying to use Marshal.GetActiveObject for my Excel automation (to get info about the current workbook where the automation is called), but I've realised that when I have multiple instances of Excel (eg, starting excel through the programs menu multiple times), the returned Application object is always the first excel application. Is there any way I can get around this problem? Basically, I want my automation to be able to get the Application in which it was called from. Thanks. Josh |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
GetActiveObject("Excel.Application") for multiple instances of Exc
If GetActiveObject works like GetObject() then I don't think there's any way
to get a specific instance of an application. Tim "JsJ_Slim" wrote in message ... Hi, I'm trying to use Marshal.GetActiveObject for my Excel automation (to get info about the current workbook where the automation is called), but I've realised that when I have multiple instances of Excel (eg, starting excel through the programs menu multiple times), the returned Application object is always the first excel application. Is there any way I can get around this problem? Basically, I want my automation to be able to get the Application in which it was called from. Thanks. Josh |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
If two instances of Excel open top right "X" close only one | Excel Discussion (Misc queries) | |||
Multiple "source" workbooks linked to single "destination" workboo | Excel Worksheet Functions | |||
excel.application.run macro1 -- added code to respond "yes" to a inputbox | Excel Programming | |||
Preventing Excel opened through webbrowser "taking over" other instances of Excel | Excel Programming |