I have an Excel spreadsheet that contains several tabs which will each be
saved off to the same folder but with different names. The file names will
follow the same naming convention (i.e. YYYY-MM Name of compay - location).

I would like to have the code create the file name for me. This files will
always be created the 2nd day after the month end. I need the date portion
of the file name to be the 4-digit year and the previous 2 digit month. I
would like a message box to be displayed prior to saving each file that will
display the proposed file name. If the name is not correct, I would like the
message box to allow you to change the file name before saving. Is there any
to do this?

--
Hlewis