I am using 2010 excel and pretty new with VBA codes. I've been looking for a code to save a workbook to its current location and on its current file name but must add the current date and the word FINAL. For example Myfile_08202012_FINAL.xlsx

I have no luck finding the code. Appreciate any help!