Below is a bit of a big macro i'm writing but I'm not sure how to edit my code to append the date after the filename. Then i'll need to refer to the exact filename later in the code?
Workbooks.Add ActiveWorkbook.SaveAs Filename:= _ "C:\test.xls", FileFormat:=xlNormal, _ Password:="", WriteResPassword:="", ReadOnlyRecommended:=False, _ CreateBackup:=False Windows("test.xls").Activate
Thanks
Bookmarks