Question Get Active file names from already running Excel and Word

[SteveMcD]

I am developing approval automation for documents with vb through .Net as an independent program (not as a vb Macro). In order for this to function I need to be able to list all currently open excel and word documents and for me to obtain the full file path of each document.

I fear I have bitten off more than I can code and am finding nothing which assists. Through the process.getprocess route I can get active handles for word and excel but after that I'm stuck.

Any help would be appreciated and if it can't be done, then let me know and I'll have to find another way around this.

 

[pramaratha]

OK, I got it. Thanks! JohnH
But this code (post no. 2 or 5) only works for those EXCEL or WORD files (or Processes) which are opened by the user; But what about the processes (word/excel) which are started by some another application (or the same application in other instant) in background. This code fails to detect those..
Can you Help?