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.


--
Blues
------------------------------------------------------------------------
Blues's Profile: http://www.excelforum.com/member.php...o&userid=30771
View this thread: http://www.excelforum.com/showthread...hreadid=504383

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" wrote in
message ...

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.


--
Blues
------------------------------------------------------------------------
Blues's Profile:
http://www.excelforum.com/member.php...o&userid=30771
View this thread: http://www.excelforum.com/showthread...hreadid=504383

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

--
Blue
-----------------------------------------------------------------------
Blues's Profile: http://www.excelforum.com/member.php...fo&userid=3077
View this thread: http://www.excelforum.com/showthread.php?threadid=50438

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

"Blues" wrote in
message ...

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 it
applicable to my situation???
http://www.mcgimpsey.com/excel/udfs/sequentialnums.html

Many thanks


--
Blues
------------------------------------------------------------------------
Blues's Profile:
http://www.excelforum.com/member.php...o&userid=30771
View this thread: http://www.excelforum.com/showthread...hreadid=504383