Barcode Sample Code

Bar Code Sample Code

Excel

The Excel spreadsheets below all include a macro that creates barcodes from your existing spreadsheet data. The spreadsheets are self-documenting and include comments about how they work and how to use them. You can edit and modify our spreadsheets to suit your needs or simply copy the macro into your own spreadsheet.

Macros and User Defined Functions for Excel 2003 & 2007:
    UPC version A  •  UPC version E  •  ISBN-13  •  EAN-13  •  EAN-8

    Code 128 code set A  •  Code 128 code set B  •  Code 128 code set C
    GS1-128 code set A  •  GS1-128 code set B  •  GS1-128 code set C

    Code 39  •  Code 39 Full ASCII  •  Code 39 check digit

    Interleaved 2 of 5  •  ITF-14  •      POSTNET

The macro code & ReadMe for Excel 2004 (Mac):
    UPC version A  •  UPC version E  •  ISBN-13  •  EAN-13  •  EAN-8

    Code 128 code set A  •  Code 128 code set B  •  Code 128 code set C
    GS1-128 code set A  •  GS1-128 code set B  •  GS1-128 code set C

    Code 39  •  Code 39 Full ASCII  •  Code 39 check digit

    Interleaved 2 of 5  •  ITF-14  •  POSTNET

Mail Merge:
    Excel 2003 and Word 2003  •  Excel 2007 and Word 2007

Crystal Reports

Azalea Software makes it easy to print barcodes right in Crystal Reports. Our User Function Library (u2lbcode.dll & barcode.dll) is a plugin that creates Code 128 barcodes, UPC barcodes, Code 39 barcodes, and Interleaved 2 of 5 bar codes in Crystal Reports including Crystal Reports 2008. In fact, if you have Crystal Reports 2008, our UFL is built right into the product.

    UPC, ISBN-13, EAN, & ISSN  •  Code 128  •  Code 39  •  Interleaved 2 of 5

By default, our setup programs install our Crystal Reports User Function Library in the correct locations on your hard drive. You can also install our Crystal Reports UFL manually.

Visual Basic

Print all kinds of barcodes from within your Visual Basic applications. Our VB sample code are custom functions you can copy to your own projects. This free Visual Basic code can also be used to write Microsoft Word macros too.

Many people use our Visual Basic routines as a reference or starting point when porting to other languages and tools.

    UPC, ISBN-13, EAN, & ISSN  •  Code 128  •  Code 39  •  Interleaved 2 of 5
    POSTNET  •  Codabar  •  Code 93  •  MSI-Plessey  •  2 of 5  •  PDF417

Access

Our products come with free sample code to integrate our fonts in Access databases. Creating barcodes in Microsoft Access is an easy two part process: pass your data in, then format the returned value into one of our fonts. You'll find instructions and sample Access databases below.

    UPC, ISBN-13, EAN, & ISSN  •  Code 128  •  Code 39  •  Interleaved 2 of 5
    PDF417

Word

Print UPC labels on adhesive sheets in your laser printer. 3 across and 10 down on a sheet. Ideal when you need to add a UPC barcode to something with the packaging already done.

    UPC labels (Word template)