Hi Mark,
If you already know the workbooks name you can just use the full pathname instead of the classname.
Set MyWorkBook=GetObject("C:\my documents\myfile.xls")

If it is a seperate instance, not multipul workbooks in one Excel instance from Windows task list.
This code will find all running instances' and you can modify the code to look for a specific instance if you know its name.
<http://www.google.com/groups?hl=en&lr=&ie=UTF-8&selm=%23d59pH8nCHA.2288%40TK2MSFTNGP10


--
John
johnf 202 at hotmail dot com


"Mark Grimes" wrote in message ...
| I have a number of instances of Excel running each containing a number of workbooks.
|
| One of the instances needs to determine the worksheet names in all the workbooks.
|
| I can use Application.Workbooks().worksheets().name to get the names from the current instance,
| but I am unable to get the information from all the other instances as I am unable to get an Application
| handle for each instance.
|
| Any ideas how I can get the handles to the other instances of Excel.
|
| Cheers,
| Mark.
|