jurdegreeuw
New Member
- Joined
- Apr 8, 2009
- Messages
- 1
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
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