GetActiveObject("Excel.Application") for multiple instances of Exc

  • Thread starter Thread starter JsJ_Slim
  • Start date Start date
J

JsJ_Slim

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
 
If GetActiveObject works like GetObject() then I don't think there's any way
to get a specific instance of an application.

Tim
 
Back
Top