I have code that pauluk82 listed in a previous solution here on EE. Could this code be modified to save to a specific location and filename? Example file path: C:\My Documents\MyFile. The saved file would also have the date on the end of the name specified. I am using Excel 2007.
ActiveWorkbook.SaveAs Filename:=Range("A1").Value & Format(Date, " mm dd yyyy")