PDF specific sheets into new created folder in Workbook location

Hi guys,

Need some help on the below code please. See code below.

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 "D2" and "D3", then the current date and time.

Name the folder in this order: "D2"" - ""D3"" - ""RFI Set"" - ""dd.mm.yyyy hh:mm:ss"

2. Inside this newly created folder, create another folder named "Individual Sheets"

3. Inside the folder named "Individual Sheets", run the code below so that the PDFs are generated inside.

4. Then I would like it to combine these generated PDFs into a single PDF and save that up a layer in the folder created at the start (In point "1." above). Naming the combined PDF file from the sheet cells in Sheet 1 as follows: "D2"" - ""D3"" - ""RFI Set"" - ""dd.mm.yyyy hh:mm"

Hopefully this is possible

Thanks for the help guys

Please Login or Register  to view this content.

Working code:

Please Login or Register  to view this content.