Invoice autonumber with mulitple number sequense

[Nicolay]

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

 

[Tom Ogilvy]

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

 

[nsdesai]

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