NameTag generator; multiple FillHandle, backwards compatible

[jurdegreeuw]

I want to make a NameTagGenerator for the lableprinter.
creteria:
-backwards compatible with 97/2003
-super userfriendly (a none(!) excel-expert must use it: he only have to enter the BeginID and the EndID and press a MacroButton and paste the resultvalue in the lableprinter)

some examples:

BeginID: THE GOOD THE BAD AND THE UGLY part 001/288
EndID: THE GOOD THE BAD AND THE UGLY part 288/288

BeginID: CABINET 2.1 PANEL A OUTLET 01
EndID: CABINET 2.6 PANEL F OUTLET 24

BeginID: C-01
EndID: K-24

some results:
THE GOOD THE BAD AND THE UGLY part 001/288
THE GOOD THE BAD AND THE UGLY part 002/288
THE GOOD THE BAD AND THE UGLY part 003/288
(snip)
THE GOOD THE BAD AND THE UGLY part 287/288
THE GOOD THE BAD AND THE UGLY part 288/288

CABINET 2.1 PANEL A OUTLET 01
CABINET 2.1 PANEL A OUTLET 02
(snip)
CABINET 2.1 PANEL A OUTLET 24
CABINET 2.1 PANEL B OUTLET 01
CABINET 2.1 PANEL B OUTLET 02
(snip)
CABINET 2.6 PANEL F OUTLET 22
CABINET 2.6 PANEL F OUTLET 23
CABINET 2.6 PANEL F OUTLET 24

C-01
C-02
(snip)
C-24
D-01
(snip)
K-23
K-24

Thanks in advance, greetings from the Netherlands

Jurriaan

 

[Legacy 98055]