build a macro that saves & names a file with the current day's date

[mariusescu]

HI,

Is it possible to build a macro that saves a file and names it with the current day's (or month) date ? e.g. (March 08.xls, March 15, 2008.xls)

thank you
marius

[Richard Buttrey]

HI,

Is it possible to build a macro that saves a file and names it with the current day's (or month) date ? e.g. (March 08.xls, March 15, 2008.xls)

thank you
marius

Hi,

Yes, just put the following code in the Workbook_BeforeSave event

Please Login or Register  to view this content.

[slc]

I got this macro from this forum sometime back. You can modify to what you want. This macro save the current active sheet into a separate workbook with the date in the filename.

Please Login or Register  to view this content.

[mariusescu]

Thanks a lot guys. You're awesome. I really appreciate your help.

Have a great day
marius