Hi!

My ideia is the following:

Create a template for an invoice that autonumbers it like so:

yyyymmdd_### eg: 20031120_001

The auto numbering method must allow me to have control on the nex
number to be choosen (even though I want it automatic most times,
just want that option so that I can correct wrong invoices);

It must not be registry based because that would loose the numbering i
I opened the file in another PC;

when I create a new invoice from the template the default name for thi
workbook when I save it would be the same as the invoice number;

When I opened a previously created invoice that was allready numbere
it would not receive a new invoice number, that would be messy wheneve
I wanted to print old invoices.


My ideia is that maybe the VBA code could keep track of the number
that were already used by checking either a second sheet or checkin
the filenames a specific folder has (eg. if it recognized the file wit
20031120_040 it would set the invoice number to the new one a
20031120_041)

Either one of this aproaches would allow me to control very easily th
numbering of invoices and would allow me to open the template/folder i
any PC and still keep the correct numbering.

The options to save the workbook with the invoice number is some cod
that specifies the default name should be the same has a specific cell
A9 in this case....

I think that's it for now.....Any gurus wanna take this one =)

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com