L
LarryP
I have VBA that uses Application.FollowHyperLink to open a Word document. My
intention is that after the users have taken note of its contents and closed
it, my code opens another Access database. Problem is, B doesn't wait for A
to complete. The Word document opens and is on top for a couple seconds, but
then the database opens and pushes the Word document into the background.
What can I do to, in effect, make my Word document acDialog so nothing else
happens until the user has closed it?
intention is that after the users have taken note of its contents and closed
it, my code opens another Access database. Problem is, B doesn't wait for A
to complete. The Word document opens and is on top for a couple seconds, but
then the database opens and pushes the Word document into the background.
What can I do to, in effect, make my Word document acDialog so nothing else
happens until the user has closed it?