This will save the latest hidden invoice counter number ready when the master is opened again. A1 Range('A1') = Range('A1') + 1 'increment hidden sequence num nosoumission = noclient & '-' & Range('A1') Sheets('Feuil1').Range('Q25') = nosoumission ActiveWorkbook.SaveAs ('c: MyFolder ' & nosoumission) 'Clear Entry fields (including cell Q25) ready for next invoice End SubWhen finished entering invoices save the workbook as the Master invoice. But they're not relevant to the invoice numbering issue.:>) Maggie.Ĭode: Private SaveButton_Click 'Hidden sequence number in any cell e.g.

And the macros that he already has come up as being turned off, but they do re-enable - however, I had to delete all pages behind this front one to make the file small enough to attach. BTW, I should advise you that I'm a total neophyte when it comes to creating macros and working in VBA (I'm using Excel 2007, but my friend is using a previous version which is why it's in 'compatibility mode'.) So if I need to do this, please explain where I need to 'go' and what I need to do. Thanks so much! Pokemon Movies In Hindi Dubbed Download Kickass. The reason I'm asking is so that it doesn't get 'ruined' if it's saved wrong, etc.

Vba auto increment file name changer