"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