Code issue - before_save() - Filename with date stamp - worksheet
Could someone tell this tourist why this is not working please??
Private Sub Workbook_BeforeSave()
With ActiveSheet
.Name = "As of " & Format(Now(), "MM-DD-YYYY")
End With
With ActiveWorkbook
.Name = "{FILENAME}" & Format(Now(), "yyyymmdd" & ".xls")
End With
End Sub
|