ERROR with PDF export by VBA, when the file is open

[mahhdy]

Hi,
I have a user form which exports a form as PDF file with a predefined name format.
I want if the same pdf file is open, VBA returns a message box asking him/her to first close the open file, then retry the export.
Actually, I don't know the error code, the rest should be ok.
Thanks as always.
M

 

[Trevor_S]

Try this:
Immediately before the line that tries to save the PDF, put:

On Error Goto PdfExportError

Immediately after the line that tries to save the PDF, put:

On Error Goto 0

At the very end of the macro, just before End Sub, add the following lines:

Exit Sub 'prevents the main code execution from running into the error handler
PdfExportError:
MsgBox("Error message to be displayed")
Exit Sub