List of open excel documents and the path of the document
-
Hello all, I need to list all the openned excel and word documents along with the path of the document. I am able to list the applications using EnumWindowsProc and Process.ProcessName. But i don't know how to find the path of the document. Can anyone help me? Thanx in advance. JRK
-
Hello all, I need to list all the openned excel and word documents along with the path of the document. I am able to list the applications using EnumWindowsProc and Process.ProcessName. But i don't know how to find the path of the document. Can anyone help me? Thanx in advance. JRK
Member 514252 wrote:
I am able to list the applications using EnumWindowsProc and Process.ProcessName. But i don't know how to find the path of the document. Can anyone help me?
Using the Windows API, there's no way to find out what the path of the file is. You'd have to use the Excel object model (Google for "Excel Object Model") to get the workbook names and paths.
A guide to posting questions on CodeProject[^]
Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic
2006, 2007, 2008