actuveworkbook.save filename:= "C:myDir\" & Format(Date,"yyyy-mmm-dd") &
".xls"

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Sharon Perez" wrote in message
...
I want to know if a macro can save a file with the name of
today's date, and and if so how is that done. Thanks!