Hi All-
I'm fairly new to VBA code so forgive me if this is extremely simple and/or poorly worded... To note: I am on Excel 2011 for MAC. What i would like to do is create one button and assign one macro to it. I would like the macro to create a dated folder with today's date (mmddyy) and then save subfolders with the folder names determined from cells A1_B1, A2_B2, A3_B3, etc.
So essentially the final directories would look like this:
Macintosh HD:Users:clairephillippi:SPREADSHEET:VERSIONS:TEST:mmddyy:
Macintosh HD:Users:clairephillippi:SPREADSHEET:VERSIONS:TEST:mmddyy:A1_B1
Macintosh HD:Users:clairephillippi:SPREADSHEET:VERSIONS:TEST:mmddyy:A2_B2
Macintosh HD:Users:clairephillippi:SPREADSHEET:VERSIONS:TEST:mmddyy:A3_B3
This is the code that I am currently using. It creates folders with the date and folder name like this: 101614A1_B1
Sub MakeFolders()
Dim FldrName As String
On Error Resume Next
dirName = "GFXM1:STUDIO:TOTAL_ACCESS:TA_14:TA_Versioning 2014:24.00_Intro_Wall:_SPREADSHEET:VERSIONS:TEST:" & " " & Format$(Date, "mmddyy"):
For i = 7 To 10
FldrName = Cells(i, 1).Value & "_" & Cells(i, 2).Value
MkDir dirName & FldrName
Next i
End Sub
Any and all help would be greatly appreciated!!!
Bookmarks