Creating Folders.

Hello everyone. I am using the following VBA code to create a folder:

Please Login or Register  to view this content.

I am trying to create a code that is a little more "dynamic". I want to write VBA code that will create a userform where the user is prompted for the date (MM_DD_YYYY) for instance: "Please Enter the date". The macro will then take that date and create a folder named "MM_DD_YYYY_157. If the folder already exist I need an error message which will promt the user to enter in the correct date, "Incorrect date, please try again!"

Any suggestions would be appreciated.

Here's how I would write that:

Please Login or Register  to view this content.

Correction:

Please Login or Register  to view this content.

You know, now that you're trying to make multiple folders, a little more robust response to finding folders already created is probably in order... try this and try running it on the same date more than once...

Please Login or Register  to view this content.