1,105,331 Community Members

Excel Macro Save as with date in file name

Member Avatar
roryt
Nearly a Posting Virtuoso
1,280 posts since Oct 2005
Reputation Points: 150 [?]
Q&As Helped to Solve: 19 [?]
Skill Endorsements: 4 [?]
 
0
 

I have posted this thread in the microsoft software forum as well but with no luck. If anyone can tell me how I can save a active excel file using a macro to save it in a folder using the current date as the file name. I hope that was clear. I know no VBA at all sorry...

Any help will be appreciated.

Thanks

Member Avatar
njreid
Newbie Poster
1 post since Jan 2007
Reputation Points: 0 [?]
Q&As Helped to Solve: 1 [?]
Skill Endorsements: 0 [?]
 
0
 

I have posted this thread in the microsoft software forum as well but with no luck. If anyone can tell me how I can save a active excel file using a macro to save it in a folder using the current date as the file name. I hope that was clear. I know no VBA at all sorry...

Any help will be appreciated.

Thanks

This will save with a value of a cell and todays date

Sub save()
ActiveWorkbook.SaveAs Filename:=Range("B11").Value & Format(Date, "mmdd")
End Sub

Question Answered as of 7 Years Ago by njreid
Member Avatar
roryt
Nearly a Posting Virtuoso
1,280 posts since Oct 2005
Reputation Points: 150 [?]
Q&As Helped to Solve: 19 [?]
Skill Endorsements: 4 [?]
 
0
 

Thanks for the post, but I have already found a perfect answer and I will try and remember to post the VBA when i can find it. Cheers

Member Avatar
leecker
Newbie Poster
2 posts since Jul 2009
Reputation Points: 0 [?]
Q&As Helped to Solve: 0 [?]
Skill Endorsements: 0 [?]
 
0
 

Hi, New here.
I tried several different statements and keep getting an error.
Compile error
Wrong number of arguments or invalid property assignment.

It highlights the Format property.

I did look in tools, references for anything missing and there was none.
What am I missing?

Thanks

This will save with a value of a cell and todays date

Sub save()
ActiveWorkbook.SaveAs Filename:=Range("B11").Value & Format(Date, "mmdd")
End Sub

You
This question has already been solved: Start a new discussion instead
Post:
Start New Discussion
Tags Related to this Article