I want to open 1-Invoice-Template-1.xlsm and have it saved with the new invoice number right away so that when I open the file the next time the invoice number increments by 1. I have programmed the invoice number to increment by 1 when the file is opened.
Right now, I press the Save File Box in the M5 area of the InputData page to save it to the new invoice name which is in M1. That works fine. But if I don't save the file first without any data entered yet on the InputData page, the next time I open the file, it stays the same invoice number.
Can I use VBA to SAVE the file as the same file name once it is opened? Or do I need to use a Macro and another image like in the M5 area to save it first?