Run-time error 1004 Document not saved....

Hi all,

I am running the Macro below to export to pdf a document.

It has worked perfectly for over a week up until today and I am not sure why I am now getting the error message. It appears that it wont save the pdf at all as the pdf file does not get created or shown on screen.

My complete macro is actually three modules, copy data to another excel sheet, print sheet and then export copy to pdf. Code as follows:

Module 1

Please Login or Register  to view this content.

Module 2

Please Login or Register  to view this content.

Module 3

Please Login or Register  to view this content.

Module 4

Please Login or Register  to view this content.

The error message I get today is Run-time error 1004: Document not saved. The document may be open, or an error may have been encountered when saving.

Please could somebody offer me an explanation as to why this has suddenly started happening and how I may be able to go about fixing it? I suspect the pdf engine is running in the background but looking at active processes I can see only the adobe update which as it happens doesnt appear to show an update is in progress.

Thank you for any help.

Thank you

Hello,

Thank you for your reply. Unfortunately Debug is greyed out on the error message therefore I only get the option to click end (or help which wasnt helpful). This again makes me think it is an issue opening the pdf software.

Quick update. The code appears to be working on my machine but not on the persons who uses the spreadsheet daily. It must be related to the pdf converter. Can anyone confirm that using my code above this is built into Excel therefore suggesting an Excel problem?

The pdf used to open to the default read software being Adobe Reader. Could this be causing the problem but I cannot see if open? Is there a code amendment that will force close any open pdf reader before processing the save and open file?

Thank you