Once successful VBA now elicits Run-time error '1004': Document not saved.

Hello,

The code below used to work with no issue. Recently is elicits the following: Run-time error '1004': Document not saved. The document may be open, or an error may have been encountered when saving.

The point of the code is to save a ststement created in excel to .pdf in a specific directory. The error has been produced on different computers, and I changed the destination directory so I don't believe it is an overwriting issue. The debug takes me to the code below.

Thoughts?

Please Login or Register  to view this content.

It produces no output. "I8" is a cell which contains the file path. Cells (i, 4) is the participant's name and Range ("A4") contains a date. So the .pdf is saved to a particular location and given the name of a participant and date.

The code worked in the past, so I don't understand why it doesn't any longer.

As I was about to write "of course the file path is correct" I followed the file path to make sure it was. It was then I noticed someone had altered the name of the directory itself. As soon as I made that correction to excel, it is working once again. Thank you shg!