vba to check for folder and create it if it doesn't exist

I have a macro that creates three reports and saves them down to folder paths which have dated month folders in them

Currently the save part of the macro looks like differing versions of this for all three of the file saves

Please Login or Register  to view this content.

Where the - " & Format(Date, "MMMYY") & "\ - portion is is the dated month folder part of the path the file needs to save down to. The issue is, on the first day of the month that folder wont exist. Now, it isn't that hard for the person running the macro to just go and add the folders themselves before they run, but if I could eliminate that step I would like to.

Is anyone able to help with how I can go about making the macro check for the folder paths and create them if needed, but to progress as normal if they already exist?

I use the MakeSurePathExists API.

E.G.

Please Login or Register  to view this content.

In my experience MakeSurePathExists does create it if it doesn't exist already.

Thanks both.
That worked a charm. I had tried googling the answer and none of the answers I found made it as easy to understand as you both did.


Thanks again

You're welcome.