ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Sequential barcodes (https://www.excelbanter.com/excel-programming/329804-sequential-barcodes.html)

Jock W

Sequential barcodes
 
On an A4 sheet, I can place four identical 'cash slips' which can, once
printed, be cut up into 4 seperate slips. I need to produce hundreds of these
'slips', but each one needs a unique bar code on it. I have inserted a 3 of 9
bar code onto each slip on the worksheet, but I need to know how to print
off, say thirty sheets with a different barcode on each slip. How can this be
achieved?

tia
--
Jock Waddington

Tom Ogilvy

Sequential barcodes
 
Dave McRitchie has information on bar codes at:

http://www.mvps.org/dmcritchie/excel...rg.htm#barcode

As far as how do you generate them, I think you would adapt Dave's example
of how 3 of 9 is entered, then write code that would generate sequential
numbers. (you posted in programming, so I assume you know how to program).

If you have a specific question, perhaps you could ask that.

--
Regards,
Tom Ogilvy

"Jock W" wrote in message
...
On an A4 sheet, I can place four identical 'cash slips' which can, once
printed, be cut up into 4 seperate slips. I need to produce hundreds of

these
'slips', but each one needs a unique bar code on it. I have inserted a 3

of 9
bar code onto each slip on the worksheet, but I need to know how to print
off, say thirty sheets with a different barcode on each slip. How can this

be
achieved?

tia
--
Jock Waddington





All times are GMT +1. The time now is 12:21 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com