1.11M Members

Excel Macro Save as with date in file name

 
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

 
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
 
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

 
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

Isn't it about time forums rewarded their contributors?

Earn rewards points for helping others. Gain kudos. Cash out. Get better answers yourself.

It's as simple as contributing editorial or replying to discussions labeled or OP Kudos

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