roxnoxsox
08-31-2015, 04:04 AM
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 :)
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 :)