Automatically saving worksheet by the date

[Bob]

How do I make a macro to save my worksheets by date(Apr
14,2004 and so on)?.

 

[Frank Kabel]

Hi
in your macro something like
dim fname
fname = format(date,"MMM_DD_YYYY") & ".xls"
activeworkbook.saveas filename:=fname