Hi

I have tried to make an Invoice template with autonumber.
The problem I can not solve is as follows:

We have x different cost centers and all of these should have
different number sequenses. What I thought was an easy task has proved
itself not to be.

The intention was that the auto_open macro should ask the user what
kind of number sequense to use (or which txt file to use as autonumber
file). I am not able to get this right. Is there somebody out there
that have an other solution to the problem or could help me with the
asking part in the auto_open macro?

Thanks for you help

Nicolay

to select a file

ChDrive "C"
ChDir "C:\TemplateNumbers"
fName= Application.GetOpenfileName( FileFilter:="Text Files (*.txt),*.txt")

- now check if fname is a valid file (one of your invoice number files)

Beyond that, you haven't given enough details

--
Regards,
Tom Ogilvy

"Nicolay" wrote in message
om...
Hi

I have tried to make an Invoice template with autonumber.
The problem I can not solve is as follows:

We have x different cost centers and all of these should have
different number sequenses. What I thought was an easy task has proved
itself not to be.

The intention was that the auto_open macro should ask the user what
kind of number sequense to use (or which txt file to use as autonumber
file). I am not able to get this right. Is there somebody out there
that have an other solution to the problem or could help me with the
asking part in the auto_open macro?

Thanks for you help

Nicolay

there can be different ways..

have a look at www.pexcel.com and at download section see
invoicing..it shows different ways to give number to
invoice


-----Original Message-----
to select a file

ChDrive "C"
ChDir "C:\TemplateNumbers"
fName= Application.GetOpenfileName( FileFilter:="Text
Files (*.txt),*.txt")

- now check if fname is a valid file (one of your invoice
number files)

Beyond that, you haven't given enough details

--
Regards,
Tom Ogilvy

"Nicolay" wrote in message
. com...
Hi

I have tried to make an Invoice template with
autonumber.
The problem I can not solve is as follows:

We have x different cost centers and all of these
should have
different number sequenses. What I thought was an easy
task has proved
itself not to be.

The intention was that the auto_open macro should ask
the user what
kind of number sequense to use (or which txt file to
use as autonumber
file). I am not able to get this right. Is there
somebody out there
that have an other solution to the problem or could
help me with the
asking part in the auto_open macro?

Thanks for you help

Nicolay


.