making a folder with vba

[Jake975]

Mkdir (""""C:\Audit Reports\Disembodied" & Format(Date , "mm-dd-yyyy"""")

How can i make a folder that is created and has a date as its name?
I know the current code doesn't work but i'm looking for a way to make it work.
Thanks in advance

 

[Legacy 456155]

mkdir "c:\audit reports\disembodied\" & format(date,"YY.MM.DD")

Just a suggestion. Your folders will sort better using YY MM DD. The dot is easier to read in a list than the dash.
Another format that is even better IMO is "YY MM DD". (2 spaces between)

 

[Jake975]

its the way the company wants it. As the employee has to go back in to edit files for the previous day. But i will bring it to their attention to see if they go for it.
thank you for your help

 

[Jake975]

where would i add a "-1" to move the date back one day?

 

[Legacy 456155]

Format(Date - 1 , "mm-dd-yyyy")
Have a nice weekend.

 

[Jake975]

thank you so much it was a long day and my mind wasn't working