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

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

Originally Posted by 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

Hi,

Yes, just put the following code in the Workbook_BeforeSave event

Please Login or Register  to view this content.

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.

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

Have a great day
marius