Date and time as file name

  • Thread starter Thread starter Guest
  • Start date Start date
You cannot save a worksheet. You can save a workbook as follows:

ActiveWorkbook.SaveAs Format(Date, "d-mmm-yyyy") & " " & Format(Time, "h:mm
AM/PM") & ".xls"
 
Back
Top