Try
Dim FName As String
FName = ThisWorkbook.Path & "\Test_" & Format(Now, "dd-mmm-yyyy")
& ".xls"
ThisWorkbook.SaveAs FName
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"JOUIOUI" wrote in message
...
I have macros that record where the file is being saved to. How
would I add
todays date in the file name. I've tried using =today() and
that didn't work
for me. Is this even possible? Thanks so much