VBA MkDir Folder

[Pinaceous]

Hi All,

I'm working with this code in producing a common file folder in the current directory.

Sub MakeMyFolders()



MkDir ThisWorkbook.path & "\mmyy"


End Sub

I'd like to use the Format(Now(), "mm-yy") to produce the current month and year for the file folder.

Can someone please help me out with this ??

Many thanks in advance!
Respectfully,
pinaceous

 

[Pinaceous]

Thanks Joe4, I'll give it a go. Take care!