VBA Print PDF Code troubles

Hi Guys,

I have some buttons on my excel sheet that print my workbook. Ive recently added pdf printing to that list.

I would like it to check if the pdf file exists, save pdf if it does not. Message box [Yes, No, Cancel] if it does exist, Yes: creates pdf, No: prompts SaveAs dialog, Cancel: ends without Pdf changes . It "almost" works.

PROBLEM: If there is no PDF there it does not detect this. It always comes up with the dialog box.

Guessing my learner skills are not what i think they are. (read: basterdise other people's code from online)

Thanks for the help

Please Login or Register  to view this content.

Use the Dir command

Please Login or Register  to view this content.