Azalea Software, Inc. www.azalea.com Free Barcode Sample Code for Excel, Crystal Reports, Access, & C/C++

Use our free barcode sample code with our fonts and create bar codes within your favorite applications: Excel spreadsheets, Access databases, Crystal Reports projects, Word documents, Photoshop files. Or write your own custom application in Visual Basic or C/C++ and wire our example code right in. Either way, you're up and running quickly and easily (because we've done all the hard work for you).

Our sample takes your input and then add the start and stop characters, calculates any necessary check digits, and then maps the result into our fonts’ character set. You don’t have to learn how barcodes work build them from scratch. Our sample code is your shortcut to success.

Because barcodes require special characters and check digits, simply typing your data in a barcode font won’t create a scannable symbol. Your data must pass through our encoder. Let our sample code do all the heavy lifting for you!

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
    UPC version A check digit (more info...)  •  UPC version E undo

    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
    UPC version A check digit  •  UPC version E undo

    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
    POSTNET  •  Interleaved 2 of 5  •  ITF-14

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

An alternative is to use the Excel XLA that ships with all of our font packages. The XLA file includes custom functions that create barcodes in your spreadsheets. Download AzaleaBarCodes.xla into your XLStart directory (Program Files\Microsoft Office\OFFICE11\XLSTART). If you're running Windows XP or Vista, insert barcode.dll into your \WINDOWS\SYSTEM32 directory. On Windows 2000, Windows Server, or WindowsNT, put barcode.dll in your \WINNT\SYSTEM32 directory. Reboot your computer and our barcode functions will appear as a user defined function in Excel.

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

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.

User Function Library (UFL):
    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.

Visual Basic functions:
    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.

Access plug-in:
    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.

Word template:
    UPC labels (Word template)


PCL barcode fonts

Our sample code library also works with our downloadable PCL bar code fonts too. In addition we have a sample PCL macro that may be of some use to you. It's so old, we've forgotten how it works. Others have found it of benefit.

free barcode softwareIf you don't see what you're looking for please ask us. After all these years we have sample code for other applications and dev tools we'd be glad to share with you.

Try out our free demo! It includes a free Code 39 barcode font that works with all of our Code 39 sample code and macros. Download it and see for yourself.

email or call us if you have questions.

Zebra printers

Here's an interesting solution if you want to print barcodes on a Zebra printer.