Excel Macro to save with Current Date?

[roxnoxsox]

I have a spreadsheet which I need to save every day and if possible, I'd like to create a VBA to do this for me as it would be quicker.

I need it to save to: W:\Common\PricingReports\Daily

The file name would be: 'Daily Automated BB Prices Upload ' and then the date after it (eg. Daily Automated BB Prices Upload 31/08/2015)



is this possible at all..? All help is greatly appreciated!


EDIT:: Found solution myself

[jolivanes]

@ roxnoxsox
Would you be so kind and show the solution for other people that look for a fix for the same problem.
Thank you very much.

[roxnoxsox]

Yep, no problem! See the code I used as below:

    ActiveWorkbook.SaveAs ("W:\Common\Pricing Reports\Daily\Daily Automated BB Prices Upload " _
                                                                                                                                                & Format(Now(), "DD-MM-YYYY") & ".xlsx")