 |  |  |  |  |  |  |  |
Excel Macro Save as with date in file name
Thread Solved |
•
•
Join Date: Oct 2005
Posts: 1,283
Reputation: 
Solved Threads: 14
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
Any help will be appreciated.
Thanks
•
•
•
•
Originally Posted by 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
Sub save()
ActiveWorkbook.SaveAs Filename:=Range("B11").Value & Format(Date, "mmdd")
End Sub
Last edited by njreid; Jan 16th, 2007 at 2:54 pm.
•
•
Join Date: Oct 2005
Posts: 1,283
Reputation:
Solved Threads: 14
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
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
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
•
•
•
•
Originally Posted by njreid
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
 |
Similar Threads
- How to Add date to file Name (Windows NT / 2000 / XP)
- Save Excel as txt (Tab Delimited) (Visual Basic 4 / 5 / 6)
- Save As Macro using date in Excel (Windows Software)
- Excel Macro VBA Help (Visual Basic 4 / 5 / 6)
- Date format in MS Office 2000 (Visual Basic 4 / 5 / 6)
- Good Luck w/This one: Excel Question VBA/Macro/other (MS Access and FileMaker Pro)
Other Threads in the Visual Basic 4 / 5 / 6 Forum
- Previous Thread: Timers in Vb6
- Next Thread: Copy from excel and paste special in ms-word
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Related Forum Features
Latest Visual Basic 4 / 5 / 6 Posts
- Today's Posts
- Unanswered Threads
* 6 429 2007 access activex add age application basic beginner birth bmp calculator cd cells.find click client code college component connection connectionproblemusingvb6usingoledb copy creat ctrl+f data database datareport date delete dissertations dissertationthesis dissertationtopic edit error excel excelmacro file filename form hardware header iamthwee image inboxinvb internetfiledownload keypress label listbox listview liveperson login looping machine microsoft movingranges number objectinsert open oracle password prime program prompt range-objects readfile reading record refresh remotesqlserverdatabase report save search sendbyte sites sort sql sql2008 sqlserver subroutine tags textbox time urldownloadtofile vb vb6 vb6.0 vba visual visualbasic visualbasic6 web window windows
