Who has the file open?

[Stephen English]

I have been using the code posted on the MVP site at
http://word.mvps.org/FAQs/MacrosVBA/CheckIfFileOpen.htm
and I would now like to find out who has the file open if it is open.
Is this possible please?
Thanks
Stephen

 

[Howard Kaikow]

Run the FileMon and Process Explorer progranms from
http://www.sysinternals.com/.

 

[Stephen English]

Hi Howard
Looks like an interesting site. However, it does not appear that I can
find the author from my VBA code. If you try to open a file from Windows
Explorer, it will tell you who has it open - can I do that in VBA?
Thanks
Stephen

 

[Shauna Kelly]

Hi Stephen

When Word opens a file, it creates a temporary 'lock' file that tells it
that the file is in use. If the document is 123456.doc, then the lock file
is ~$3456.doc, and it's in the same folder as 123456.doc.

Open the lock file as plain text: you can read the user's name in the file.

For obvious reasons, it will report spurious results if more than one person
has opened the file.

Hope this helps.

Shauna Kelly. Microsoft MVP.
http://www.shaunakelly.com/word