Find person blocking a document

[metropol]

Hi.

I wonder if there is possible to find the username that is blocking a document from beeing opened in write mode, using vba code.

I have a macro that opens a document for updating some information fields. This is not possible if another person is using the same document. I can not use "shared" function on the document since this is not an option for the sheet.

I can see that a dialog box appears telling me that user xxxyyy is using the document and that it is opened in protection mode. But I can't find the correct code for this.

Thanks.

 

[DiscoPistol]

Sorry found a flaw. Will take another look.

 

[Smitty]

See Ivan Moala's API call here: http://www.mrexcel.com/forum/showthread.php?t=63342

HTH,

 

[metropol]

See Ivan Moala's API call here: http://www.mrexcel.com/forum/showthread.php?t=63342

HTH,

I have no problem finding out if the file is read-only (used by another person), the challenge is to extract the username of the other person. When i try "username" in the code, it is my username and not the other guy.

My initial thought was that this is a windows message, and not an excel messag

 

[Andrew Poulsom]

Maybe this will help you:

http://www.xtremevbtalk.com/showthread.php?t=44892

 

[metropol]

Maybe this will help you:

http://www.xtremevbtalk.com/showthread.php?t=44892

Thanks Andrew. I will have a closer look at this link(s)

 

[Smitty]

Or this one:

http://www.xcelfiles.com/IsFileOpen.html

 

[metropol]

Thanks. It's working.