Save As style

  • Thread starter Dimitris from Greece
  • Start date
D

Dimitris from Greece

I run every day a workbook and I need to save it (using a macro) with name,
the date value, e.g. 20041231.xls
I can do that? Which is the syntax for this macro?
 
F

Frank Kabel

Hi
try something like
activeworkbook.saveas filename:=format(date,"yyymmdd") & ".xls"
 
Top