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
Sandy <(E-Mail Removed)> wrote in message
news:349001c37588$054f48f0$(E-Mail Removed)...
> 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
>
> >-----Original Message-----
> >Suggestion: provide more detail.
> >
> >What you have said is way not enough for anyone to answer
> you.
> >
> >TC
> >
> >
> >"Sandy" <(E-Mail Removed)> wrote in message
> >news:2eb201c374c8$3afce7c0$(E-Mail Removed)...
> >> 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
> >
> >
> >.
> >
|