BorlandTalk.com

Shyam · Guest

How can I get the reference of running excel Instance which in not active.

I opened 2 instances of Excel application to send data from Delphi
application.
I am using delphi 6 version . In the first instance I opened 'Book1'
workbook and
it is running. I opened other workbook 'Book2' using new instance instead of
using
running instance. I need to connect Book2 to send the data.

I used these two methods

1) GetActiveOleObject(...)

2) ConnectTo(...)

But I got the reference of Book1 instance which is active.
How can I get the reference of Book2 instance with out closing Book1
instance.

Pls help.