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

 

[Domenic]

Try it like this...

MkDir ThisWorkbook.path & "\" & Format(Date, "mm-yy")

 

[Pinaceous]

Try it like this...

MkDir ThisWorkbook.path & "\" & Format(Date, "mm-yy")

Hi Domenic ?,

Okay, that's great ?

Now, how can I add a specific generic name to the title, adding onto the date format to the above code in producing the file folder name?

For example, if I want "ForestGump" to be placed in the title prior to your date format to produce "Forest Gump10-19". How can I do this?

Many thanks,
Paul

PS. Good to hear back from you ?

 

[Joe4]

Note that you are just sewing each piece of what you are building together with the ampersands (&). So to add hard-coded text, just add that piece in like:

MkDir ThisWorkbook.path & "[COLOR=#ff0000]\Forrest Gump[/COLOR]" & Format(Date, "mm-yy")

 

[Pinaceous]

Note that you are just sewing each piece of what you are building together with the ampersands (&). So to add hard-coded text, just add that piece in like:

MkDir ThisWorkbook.path & "[COLOR=#ff0000]\Forrest Gump[/COLOR]" & Format(Date, "mm-yy")

Hi Joe,

Thanks very much!

Paul

 

[Pinaceous]

Hi Joe4,
I have a question for you that came up.

What happens if "Forest Gump" is named in your workbook and you are referencing it in your code. How would you do that? How would you reference it?

For example, if "Forest Gump" is in Workbook(2) cell A77 how would you reference this here as the folder title in lieu of writing it out in your code?

How would you do this?

Many thanks,
Pinaceous

 

[Domenic]

Hi Pinaceous, try...

MkDir ThisWorkbook.path & "\" & workbooks(2).Worksheets("Sheet1").range("A77").value & Format(Date, "mm-yy")

Change the sheet name accordingly.

 

[Pinaceous]

Hi Domenic,

That's really cool ? thanks

 

[Pinaceous]

Since we are on this subject, is there anyway to create a folder and subfolders within it?

For example, create folder "Movies" and then within it "Forest Gump" & "Harry Potter" based upon the code above? Or would this be two separate codes?

Please let me know, when you get a chance.

Thanks guys!

 

[Joe4]

Just keep using "MkDir" to make your directories.
You can use it more than once in your code.

Give it a try, and see how you do. If you run into issues, post your code attempt and we can help you clean it up.