DH Templates

how to increase invoice number every time i open an invoice template for excel.?

how to increase invoice number every time i open an invoice template for excel. I want to have an invoice template in excel where everytime i save it, it automatically saves it under 0001, then the next time, it will be 0002.( but it has to save automatically) and continues saving itself with the adding of one at the invoice number. oh!, and if it can open up with the invoice number which it will save itself. EXAMPLE: i open the template, it opens with the invoice number 10025. i save it, and automatically, it has 10025 as the name for the file to save it as. next time i open it, it will open with 10026 and save under 10026.

Public Comments

1. Here's a link that will do what you want. You will need to paste some VBA code in your excel File. Be sure that you paste the code under "ThisWorkbook" which you can access under 'view', 'project explorer'. (all in your VB editor under tools, macro, visual basic editor) The code you want is right at the bottom of the thread. You will have to tweak it to your specifications. Read the thread, it's pretty helpful. - also, in the suffix constant, you'll want to add ".xls" otherwise it won't save it with a file type. Hopefully this helps. I tested it on my excel and it seemed to work alright.