DaniWeb IT Discussion Community - Excel Macro Save as with date in file name

DaniWeb IT Discussion Community (http://www.daniweb.com/forums/index.php)

- Visual Basic 4 / 5 / 6 (http://www.daniweb.com/forums/forum4.html)

- - Excel Macro Save as with date in file name (http://www.daniweb.com/forums/thread57602.html)

roryt

Oct 10th, 2006 4:39 am

Excel Macro Save as with date in file name

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

Jan 16th, 2007 1:53 pm

Re: Excel Macro Save as with date in file name

Quote:

Originally Posted by roryt (Post 261933)

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

Jan 16th, 2007 3:15 pm

Re: Excel Macro Save as with date in file name

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

Jul 9th, 2009 4:53 pm

Re: Excel Macro Save as with date in file name

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

Quote:

Originally Posted by njreid (Post 302231)

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

All times are GMT -4. The time now is 4:36 am.