Hey all,
I have an excel workbook, that I want to be saved as with the filename being the current date. I can't seem to get it. Help please!
Sub Backup() ChDir "C:\Users\T431MIH001\Pictures\C9" ActiveWorkbook.SaveAs Filename:= _ "C:\Users\T431MIH001\Pictures\C9\Date", FileFormat:= _ xlOpenXMLWorkbookMacroEnabled, CreateBackup:=False StartTimer ' Reschedule the procedure End Sub
Bookmarks