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

Similar Threads

More about trying to automation multiple Excel instances 10
Workbooks collection is empty even though the some of the document is open 12
Multiple instances of Excel 11
Copy paste formulas when running multiple instances of excel 2
Prevent multiple instances of Excel from starting 8
How do you capture the name of the current worksheet in VBA? 12
Multiple instances of Excel and VB 2
IgnoreRemoteRequests & multiple Instances 1

Top