Majikthise
asked on
Save As macro to a specific location with date
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.
Thank you,
Toby
Thank you,
Toby
Sub SaveDate()
ActiveWorkbook.SaveAs Filename:=Range("A1").Value & Format(Date, " mm dd yyyy")
End Sub
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER