If you know the FullName of a file that's uniquely open in an instance then
you can use

On error resume next
set xlApp = GetObject(strFullName).Parent
If not xlApp is nothing then

So if you are concerned with various known files that may be open in
different instances (not open multiple as read-only) you can set up an array
or collection of WithEvents excel.application type class's.

If you don't know a unique file in given instances it's significantly more
complicated.

Regards,
Peter T


"Xav" wrote in message
oups.com...
For my application I would like to retrieve all Excel instances
runnning on a specific machine. Basically I want to use the GetObject
method and stock it in an array or whatsoever. Does anybody have an
idea?
Thanks for helping.