I have the month end Month and Year in Cell E6
I have the file name below
David James Comm.Oct 2021 New deals Ver 1.1.xlsm
I would like a macro to save the file by first removing the month and year after the . and before "New" and to include the month and year in Cell E6 after the .
If E6 contains Nov 2021 then the new file should save as David James Comm.Nov 2021 New deals Ver 1.1.xlsm
Your assistance is most appreciated
I have the file name below
David James Comm.Oct 2021 New deals Ver 1.1.xlsm
I would like a macro to save the file by first removing the month and year after the . and before "New" and to include the month and year in Cell E6 after the .
If E6 contains Nov 2021 then the new file should save as David James Comm.Nov 2021 New deals Ver 1.1.xlsm
Your assistance is most appreciated