Code to see if a user already has a file open

  • Thread starter Thread starter Sandy
  • Start date Start date
S

Sandy

Hello!

I need a piece of code that checks to see if a user has a
document open.

Any suggestions will be greatly appreciated!

Sandy
 
Suggestion: provide more detail.

What you have said is way not enough for anyone to answer you.

TC
 
Dear TC:

Thanks for your response.

I am running code that uses several documents. If a user
inadvertently has one of those documents open, I want code
that will figure that out and return a message . . .
something to the effect of:

If document currently open, inform user to close the
document and try the procedure again.

Sandy
 
Hi Sandy

What do you mean by "running code that uses several documents"?

Do you mean VBA code within an Access database?

If so, has that VBA code started an application to open the documents?

If so, what is that application? (Word? Excel? something else?)

TC
 
Back
Top