Test to see if a document is opened for editing by another userbefore open.

[Chrisso]

Hi All

Is there a way I can test to see if a document is opened for editing
by another user before I try to open it?

I would like to be able to make a call to test if my Documents.Open
will be successful and not result in the pop-up "The files is locked
for editing by 'another user'".

Is it possible to test for this? Thanks in advance for any answers.

Chrisso

 

[Ian B]

Hi Chrisso

AFAIK you will need to use an API call from VBA.
If you wish to go down this path I can give you some sample code.
The code checks the file to see whether it can be opened exclusively.

Cheers

Ian B