The user saves the file and be prompted to save it via save dialog. The name is already inserted in it for him such asFor question 1, just change the initial filename to this "%USERPROFILE%\Desktop\Monthly Sales Report - month year".
As for your second question, I am getting confused and I am not sure I understand what is supposed to happen. Can you explain what the scenario is ?
"Monthly Sales Report - "
Now he saves it without changing the above and excel will not permit it. So far your code has achieved this.
Now a MsgBox telling him to add month and year at the end of the name. He is prompted again with the same name "Monthly Sales Report - " and hit on the Right arrow key and enters "May 2020" ,
giving the complete name "Monthly Sales Report - May 2020"
He saves with the above name and this should have been permitted. but with your latest code it is not allowing this as well. because of compare function perhaps. which means the user will have to remove the hyphen sign - from right and then add month and year like this
"Monthly Sales Report May 2020" in order for it to work. the hyphen is important to stay though.
Hope it is clear. but I will be more than happy to clarify anything.