How can this be changed to increment the date into the filename?
Desired filename and format: Bruce Shortage Report ddmmyy.xlsx
can mm be abbreviated month like Dec, Nov, ?
I get sick of having to go out to the W drive and adding it everyday.. thanks -R-
ActiveWorkbook.SaveAs Filename:= _
"W:\Holland\rrw5\Bruce Shortage Report.xlsx", FileFormat:= _
MsgBox ("File Saved to W:\Holland\rrw5\ [ ]")