2 excel application

[tom taol]

there are 2 the number of excel applications. see the below.

you must open excel application as below.
''''''''''''''''''''''''''''''''''''''''''''
window start menu -> run -> excel -> enter
once more,,
window start menu -> run -> excel -> enter
''''''''''''''''''''''''''''''''''''''''''''
workbook in a first excel name is "controler.xls"
workbook in a second excel name is "controled.xls"

and then make a button in a worksheet in controler.xls.
And press the button and then must be appeared in message box with
"controled.xls is opend in the other excel application"

please, xl genius @@

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

 

[Dave Peterson]

Take a look at this kb article:
http://support.microsoft.com?kbid=138621

 

[Vic Eldridge]

Hi Tom,

The only way you can automate an instance of Excel that has been started
manually, is to use GetObject() function. Unfortunately, if there are two
instances of Excel that were both started manually, GetObject() can connect
to only one of them, not both, and there is no way to control which instance
it
will connect to.

I suggest you try to start both instances programmatically, using either early
or late binding. Only then can you connect to two separate instances of Excel.


Regards,
Vic Eldridge