Making the date a part of the file name

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?
 
K

kimt

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
 
Top