Macros for saving the file with sertain file name

[buskopan]

Macros for saving the file contains


ActiveWorkbook.SaveAs Filename:="H:\link to folder\some_words.xlsx",

How to make it save as H:\link to folder\some_words_"todays date in format(dd.mm.yr).xls

[westconn1]

try like
ActiveWorkbook.SaveAs "H:\link to folder\some_words_" & format(date, "dd.mm.yy") & ".xls"

[buskopan]

Thank you!