Self saving Excel 2007 template with Invoice number generator

I have created an Invoice template using excel 2007.

The actual "Invoice Number" is stored in a cell (K 3)

I am looking for a VBA procedure or function which runs when the spreadsheet opens.

On opening the spreadsheet the following events could occur

1. Cell K 3 (the invoice number) is incremented by one.

2. The (template) spreadsheet is then saved (with the invoice number incremented so that next time the template is instantiated, the invoice number will be one higher)

3. The spreadsheet then calls a (save as) function and saves itself in an "invoices" directory eg: "x:\invoices"
with the filename Invoice12345.xls (where in this example, 12345 is the newly incremented invoice number)

I know a little bit of VBA, but I am an Excel newbie and was hoping someone could help.
Thanks in advance for anyones help with this!

Here is the basic code which, admittedly, is not very robust in terms of error checking, but I'm inclined at the moment to put more effort into it. Do some searching on checking to see if a folder/file exists, etc.

In the workbook open event and used to increment K3.

Please Login or Register  to view this content.

Code to create the invoice workbook as new file and saved to a fixed location that exists.

Please Login or Register  to view this content.