Excel Macro Save as with date in file name

[roryt]

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

[njreid]

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

[roryt]

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

[leecker]

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