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

MajikthiseAsked:
Who is Participating?
 
Saurabh Singh TeotiaConnect With a Mentor Commented:
Did you meant this...??
Saurabh...

Sub SaveDate()
 
ActiveWorkbook.SaveAs Filename:="C:\My Documents\MyFile\Your Name that you want to give" & Format(Date, " mm dd yyyy") &".xlsm"
End Sub

Open in new window

0
 
MajikthiseAuthor Commented:
Yes, that is what I need.  Thanks for your help!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.