Is there a way of getting the qualified name (ie full path + name) of a file that is currently open by an foreign application without using Automation.

So for example, let's say a running instance of Excel has a workbook open. How can I get ,from my VB application, the full path of this WorkBook file ?

As I said , I don't want to use Automation with which I could easily use the VB GetObject function .This is because I need this for other applications that do not support Automation.

I assume this could be solved via some API programming..well I hope so

Hope this make sense.

Any takers.