Macro to change file name daily

[Anar]

Hello,


Can anyone suggest a code to change the date in Excel file name daily.

File name is in this format: FileName_Date

FileName will stay the same each day, Date should change every day


BR,

Anar

 

[Anar]

This post should be saved in VBA & Macros forum, sorry for that.

I could not edit it and save in VBA & Macros forum

 

[xld]

[pre]

Activeworkbook.SaveAs "myfile_" & Format(Date,"yyyy_mm_dd")

[/pre]

 

[Anar]

Thanks