shortly, i want to open 2 Excel applications. as below.
window start menu - run - excel - enter
once more,,
window start menu - run - excel - enter

It won't work Tom.
GetObject() is the only way to connect to a manually started instance.
If multiple instances are running, GetObject() will connect to only one of
them.
GetObject() provides no control over which instance it connects to.

Try to start both instances programatically and establish your connections
there.

Regards,
Vic Eldridge


"tom taol" wrote:



the excel file is opend.

Dim xlApp As Excel.Application

Set xlApp = CreateObject("excel.application")

'see the below
'i want to open the specific excel file of the other excel instance. and
then I want to handle the "prob.xls" with current excel application.
ex)xlApp.sheets(2).select

xlApp.open("c:/fig/prob.xls")

xlApp.sheets(2).select

MsgBox xlApp.sheets(2).range("B2").value

shortly, i want to open 2 Excel applications. as below.
window start menu - run - excel - enter
once more,,
window start menu - run - excel - enter

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