finding a specific excel object

[christhedonstar]

Hi,

How in VBA in Excel would I search for all Excel.exe processes that currently exist on the machine and set a reference to the Excel object which has a workbook called "TheWorkBookIWant.xls"?

Thanks,

Chris

 

[PHV]

Why not simply this ?
Set myWBobj = GetObject("TheWorkBookIWant.xls")
Set myXLapp = myWBobj.Application

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[christhedonstar]

It just tries to open the sheet in the current session...

 

[christhedonstar]

That was on someone elses machine on mine - I get run-time error '-2147221020 (800401e4)'

Automation error
Invalid syntax

 

[christhedonstar]

need to put full path - no idea what was going on on the other guys machine. Cheers.