VBA to create a folder on a network drive before saving the file to it?

**jonvanwyk** · 12-29-2011, 10:04 AM

I am using the code below to convert worksheets into PDFs and then automatically save them to a specified location on a network drive. The code currently requires the folders [to which the PDFs are being saved] to already exist. What if I do not want to create the folders in advance? I built the workbook to be able to used for the next 20 years and I don't really feel like making 520 folders. Can I modify the macro to CREATE the folder if it does not already exist? In this case, when the button is pushed, it looks for the subfolder "070112 - 071412" within G:\Timesheets\PDF Archive\2013\ and saves the PDF to it. If the subfolder "070112 - 071412" is not already there, can the code create the folder and then save the PDF to it?

Please Login or Register  to view this content.

**Firefly2012** · 12-29-2011, 10:13 AM

You can check if a Folder exists:

Please Login or Register  to view this content.

**royUK** · 12-29-2011, 10:14 AM

Where will the code pick up the folder name from?

**jonvanwyk** · 12-29-2011, 10:23 AM

In this particular macro, the folder name would be derived from the date range located in cell "B20" located on worksheet "Menu", which in this case is "070112 - 071412".