Check whether a PDF file is open before attempting to overwrite?

[Pedsdude]

I have some VBA code to save an Excel Worksheet as a PDF file. Within this code, I've included two checks - the first to ensure that a 'legitimate' filename has been provided, the second to ensure that the user does not accidentally overwrite a pre-existing report PDF.

Both of these checks work as intended, however, I have come across one issue.

If the user decides to overwrite a pre-existing PDF, but has that PDF file open at the time of exporting, then the following run-time error arises:

Run-time error '1004':

Document not saved. The document may be open, or an error may have been encountered when saving.

So my question is - is it possible to check whether the PDF file is already open?

If it is not possible, what would be the best solution? The only idea I have currently is to add an "On Error GoTo" line directly before the "ActiveSheet.ExportAsFixedFormat ..." line, and work on the assumption that the only error likely to arise will be as a result of this.

Below is the code:

Please Login or Register  to view this content.

[Dimitrov]

How about using On Error Resume Next? After the line where you set your display alerts to false, put in the following:

Please Login or Register  to view this content.

This is not all that much different from the error code you are receiving, but at least with this error trapping scheme, the warning you get does not seem as dreadful as the VBA error that comes up, and the code keeps executing.

[Pedsdude]

Aha, thank you very much!