Making the date a part of the file name

  • Thread starter Thread starter Mick
  • Start date Start date
M

Mick

Does anyone know if there is a way to make the date/time a
part of the file name using symbolics (i.e filename_%
date%.xls) instead of having to key it in manually?
 
Try this code, it worked for me

ActiveWorkbook.SaveAs ActiveSheet.Range("the cell number"),

you will need to format the cell referenced to the date and time forma
you want. Good luc
 
Back
Top