"I need to create a folder each time a certain macro is run, but the folder name needs to be dynamic, i.e. [folder name] + date or numbering system"

Sub MakeFolder(fulldriveandpath)
    ' make a folder (long names are OK)
    '   use like this:
    '   MakeFolder "c:\test folder"
    '   you may need to change this next line for NT or for non-standard Windows installs. . .
    Const strWinCommand = "c:\windows\command.com"
    Dim strCommand As String
    strCommand = strWinCommand & " /c MD " & Chr(34) & fulldriveandpath & Chr(34)
    Shell strCommand
End Sub