Increment Macro - Order numbers

[Blues]

Hello.

I have set up a worksheet, using the increment macro, which enables me
to send purchase orders via e-mail. Every time i go into the work
sheet, i run the macro and the invoice number increases by one giving
me a unique order number each time. I then save the file as that order
number so i have a copy of the order that was sent.

However, i was wondering whether there would be a way of the order
number increasing by 1 automatically every time i opened the template
(as opposed to every time i open the template i have to run the
macro)?

Any suggestions would be appreciated, thanks.

 

[NickHK]

Blues,
Workbooks have a Workbook_Open event which fires every time the workbook is
opened.
Move you increment code to there.

But if this is in a template, where do you store the "next number" ?

NickHK

 

[Blues]

Im pretty new to all of this so...

What is the workbook open event? How do i access it???

How do i store the 'next number'??? Where should i store it?

I've just found this article, trying to plod along through it, is i
applicable to my situation??
http://www.mcgimpsey.com/excel/udfs/sequentialnums.html

Many thank

 

[NickHK]

Blues,
In the VBA IDE, double click on "ThisWorkbook", then from the drop down at
the top that say "(General)", select "Workbook" and you will get the outline
of the Workbook_Open sub.
I'd say that was pretty much exactly what you are after.

NickHK