Save As style
 

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?

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


--
Regards
Frank Kabel
Frankfurt, Germany

Dimitris from Greece wrote:
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?