buskopan
08-11-2014, 03:03 AM
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
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