How to create a template that creates and saves as sequencial num.

[Guest]

I am trying to create a Purchase Order template that will automatically
update the purchase order number to the next sequencial number when opened
and will have an activex button that the user can save the worksheet as that
po # automatically.

I am working with Excel 2003.

 

[Guest]

sub auto_open
Range("A3")=Range("A3")+1
end sub

supposing range A3 is where u have the bill number, each time you open the
file, it's going to increase the number in one

 

[Gord Dibben]

Viper

Have a look at John McGimpsey's site.

http://www.mcgimpsey.com/excel/udfs/sequentialnums.html


Gord Dibben Excel MVP

 

[Guest]

Am I correct that Auto_Open is still provided primarily for backward
compatibility and eventually will be deleted?

Workbook_Open is what I am using.

Lou

 

[Gord Dibben]

That would be my assumption.

Auto_Open is a holdover from pre-97 version when we still used Module Sheets.

I did very little with VBA in those days(don't do that much now) so don't know
if there even was a Thisworkbook object to run code from.


Gord