Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to create a template that creates and saves as sequencial num.
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to create a template that creates and saves as sequencial num.
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to create a template that creates and saves as sequencial num.
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" 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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to create a template that creates and saves as sequencial
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" 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. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to create a template that creates and saves as sequencial
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" 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
template creates invoice - how to create summary worksheet? | Excel Discussion (Misc queries) | |||
edited spreadsheet saves as template | Excel Discussion (Misc queries) | |||
Excel - automatically saves as a 'TEMPLATE' | Setting up and Configuration of Excel | |||
How do i create a macro that saves the filename that is equal to a cell in the sheet? | Excel Discussion (Misc queries) | |||
Create a prompt as a person saves a file | Excel Worksheet Functions |