Locked FIles

[Jimbob]

I'm using the Word object's Open method to open a file, eg

Dim objWordApp as Word.Application
Dim objWordDoc as Word.Document

     Set objWordApp = New Word.Application
     Set objWordDoc = objWordApp.Documents.Open <Path>

This works fine, unless the file is opened by another user (or anothe rprocess) in which case the program hangs while waiting for a response to a message that the user can't see.

Is there any way to check if the file is locked before opening it. Being able to find out the name of the workstation that has it locked would be even better.

[peet]

maybe if u set the Visible parameter to true, it will show the msgbox...

Set objWordDoc = objWordApp.Documents.Open <Path>, , , , , , , , , , , True

[chenko]

If you open it for read only it dont matter if another use has it open.

[Jimbob]

I was probably a bit brief in the description of my problem...

The word application is opened in the background. Values are inserted into fields in the document and the document is saved with a unique name. All this happens when the user selects an option on a form, and should be invisible.

I've tried making a copy of the document, with the unique name and opening that, b ut that causes a whole load of other problems that i'd rather not go into.

[peet]

what if u turn off the word alerts? like this :

Dim objWordApp as Word.Application
Dim objWordDoc as Word.Document
 
     Set objWordApp = New Word.Application
     objWordApp.DisplayAlerts = wdAlertsNone
     Set objWordDoc = objWordApp.Documents.Open <Path>

would that do any good ?

[Jimbob]

that's spot on

cheers!

[peet]

your welcome Jimbob

[shragel]

Or create the document as a template, then it will open a new copy every time.