Archive of Mr Excel Message Board

Back to Forms in Excel VBA archive index
Back to archive home

Bar Codes

Posted by Peter Clarke on December 14, 1999 5:28 AM

How can I print bar codes in excel.
I am downloading data from an AS/400 into a sheet
and then formatting the data. However we require to
print bar codes of some of the cells. Any ideas??

Re: Bar Codes

Posted by Chris on December 14, 1999 10:47 AM

Peter,

All you need is a bar code font. These are available from a number of vendors. Here's one of them:

http://www.taltech.com/

HTH,
Chris

Re: Bar Codes

Posted by Bob Sovers on December 15, 1999 9:52 AM

Using a barcode font will work ok if the barcode is only made up of the information in the field that would normally print (i.e. the characters.) Some barcode symbologies have extra characters leading and trailing the actual "characters". Also some symbologies have a check digit inserted to allow the entire field to be verified.

Having said all that, I still cannot come up with a better approach to use than a barcode font.

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.