How can I save or open file as YYYYMMDD in Macros
 

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

How can I save or open file as YYYYMMDD in Macros
 

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