Suppressing 'File in Use' Dialog in Word

J

John Donofrio

Hello,

I am working on an MDB that stores data for use in an
Excel file and a Word Doc. The data in both these files is
linked (XLS to MDB, and DOC to XLS). The MDB performs
updates to the other two files when data has changed. I do
not want automatic updates since the DOC file will be
delivered to other locations that will not have access to
the DataSource files.

Here is the issue:
In Excel I can detect when the file is open by another
user and not available for updates, then relay this to the
user via a MsgBox. In Word, however, I get the subject
dialog when the DOC is open by another user. I would like
to supress this dialog and test for ReadOnly and then let
the user know this file is not available for updates since
it is open by another user.

Any ideas / tips?

Thanks in advance,
John
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top