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!