Link to home
Start Free TrialLog in
Avatar of Majikthise
MajikthiseFlag for United States of America

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
Sub SaveDate()
 
ActiveWorkbook.SaveAs Filename:=Range("A1").Value & Format(Date, " mm dd yyyy")
End Sub

Open in new window

ASKER CERTIFIED SOLUTION
Avatar of Saurabh Singh Teotia
Saurabh Singh Teotia
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Majikthise

ASKER

Yes, that is what I need.  Thanks for your help!