hi, I am trying to do something simple in excel 2013 vba but it's not working. I just want to save a version of the active workbook in the existing subdirectory but with a date stamp at the end of the file name. I am using the code below. appreciate any help.
![]()
Sub Save_File_Today_Date() ' save file with today's date ActiveWorkbook.SaveAs Format(Now(), “DD - MMM - YY”) End Sub
Bookmarks