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

[Viper]

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.

[filo666]

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
"Viper" wrote:

> 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.

[Gord Dibben]

Viper

Have a look at John McGimpsey's site.

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


Gord Dibben Excel MVP

On Tue, 6 Dec 2005 13:29:02 -0800, "Viper" <Viper@discussions.microsoft.com>
wrote:

>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.

[Rookie 1st class]

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" wrote:

> Viper
>
> Have a look at John McGimpsey's site.
>
> http://www.mcgimpsey.com/excel/udfs/sequentialnums.html
>
>
> Gord Dibben Excel MVP
>
> On Tue, 6 Dec 2005 13:29:02 -0800, "Viper" <Viper@discussions.microsoft.com>
> wrote:
>
> >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.
>

[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

On Wed, 7 Dec 2005 14:29:02 -0800, "Rookie 1st class"
<Rookie1stClass@SpamThis> wrote:

>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" wrote:
>
>> Viper
>>
>> Have a look at John McGimpsey's site.
>>
>> http://www.mcgimpsey.com/excel/udfs/sequentialnums.html
>>
>>
>> Gord Dibben Excel MVP
>>
>> On Tue, 6 Dec 2005 13:29:02 -0800, "Viper" <Viper@discussions.microsoft.com>
>> wrote:
>>
>> >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.
>>