Excel Macro Save as with date in file name

•

What is DaniWeb IT Discussion Community?

You're currently browsing the Visual Basic 4 / 5 / 6 section within the Software Development category of DaniWeb, a massive community of 391,550 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,566 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our Visual Basic 4 / 5 / 6 advertiser:

Thread Tools Display Modes

Views: 16768 | Replies: 2 | Solved

•

Join Date: Oct 2005

Location: Northampton UK

Posts: 1,141

Reputation: roryt will become famous soon enough

Rep Power: 6

Solved Threads: 9

roryt

Offline

Veteran Poster

Excel Macro Save as with date in file name

Oct 10th, 2006

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

PhotoShopthis
FlyingPen
Codesnippets
Tutorials
HttpGuru

•

Join Date: Jan 2007

Posts: 1

Reputation: njreid is an unknown quantity at this point

Rep Power: 0

Solved Threads: 1

njreid

Offline

Newbie Poster

Re: Excel Macro Save as with date in file name

Jan 16th, 2007

•

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

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

Last edited by njreid : Jan 16th, 2007 at 1:54 pm.