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!