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