How can I save or open file as YYYYMMDD in Macros

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Activeworkbook.SaveAs Filename:=Format(Date,"yyyymmdd")

as a starter

--
HTH

Bob Phillips

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