Need to generate unique serial numbers using algorithm

This is an interesting problem. Have you considered a combination of
digits limited in their range, something like:

Digit 1: can only be 1 or 0
Digit 2: can only be 3 - 7
Digit 3: can only be 4 - 8

and so on. Then use the VBScript Regular Expressions library or write
your own parser to confirm the rules have been met.

It shouldn't be too difficult to make a number that can be validated without
a
database, but where will the code be that validates the number?
As mentioned many times in this NG the security of Excel is not very good.
Maybe this needs to be tackled first.

RBS


"chillihawk" <chillihawk@yahoo.es> wrote in message
news:1144394831.169358.85120@i40g2000cwc.googlegroups.com...
> This is an interesting problem. Have you considered a combination of
> digits limited in their range, something like:
>
> Digit 1: can only be 1 or 0
> Digit 2: can only be 3 - 7
> Digit 3: can only be 4 - 8
>
> and so on. Then use the VBScript Regular Expressions library or write
> your own parser to confirm the rules have been met.
>