Hello.
I wish to save a new copy of my workbook as a .xls file into a particular folder using a new filename using current day logic.
My current file is a .xlsm file.
The filename I wish to save as:
101 My P&L 28 May 2019
The underlined parts of my filename need to update everyday...