Print to PDF into created folder in Workbook location

Hi guys,

Need help on this one please, not sure how to go about doing it. I have the code below that I have been using up until now which prints the active sheet to PDF in the Downloads folder.

What I would like it to do is to do the following, in sequence:


1. Create a new folder in the location of the Workbook. Name this folder based on the contents of worksheet cells "B4" and "B5", then the current date and time.

Name the folder in this order: "B4"" - ""B5"" - ""dd.mm.yyyy hh:mm:ss"


2. Inside this newly created folder, run the code below so that the PDF is generated inside.


Thanks for the help guys

Please Login or Register  to view this content.

Hi Marc,

Got this working yesterday, please see below:

Please Login or Register  to view this content.

Thank you