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

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
 
T

Tim Williams

If GetActiveObject works like GetObject() then I don't think there's any way
to get a specific instance of an application.

Tim
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top