How can I save or open file as YYYYMMDD in Macros

[Guest]

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

 

[Bob Phillips]

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

as a starter

--
HTH

Bob Phillips

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