Code to see if a user already has a file open

[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

 

[TC]

Suggestion: provide more detail.

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

TC

 

[Sandy]

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

 

[TC]

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