Activeworkbook.SaveAs Filename:=Format(Date,"yyyymmdd")

as a starter

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Vijay Kotian" wrote in message
...
In Macros, How is it possible to record for a file name as YYYYMMDD to
open
or save file names. Please inform me if possible with any other
alternatives
to save or open files with similar naming convention in Macros. OR to pick
up
name of the file from any cell where today() is mentioned