AnsweredAssumed Answered

Save as PDF but check for open document first

Question asked by Dallas Havens on Dec 16, 2014
Latest reply on Dec 22, 2014 by Dallas Havens

I have compiled some code from several posts on this forum to create a macro that will save a document and then if the document is a drawing save a PDF file in the same location. The macro works great but the only problem is that if the pdf file already exists and is open by me or another user it hangs up until the file is closed.

 

Is there a way to check to see if there is a pdf by the same name already open by someone and bring up a dialog box that will notify the user and give a choice to either continue or exit?

 

Attached is the macro I am currently using.

 

Thanks in advance for any help you may provide.

 

Message was edited by: Dallas Havens

Attachments

Outcomes