Printing Bar Codes in Excel

You can make barcodes right in Microsoft Excel with Azalea Software’s barcode fonts. Our bar code software can help you use Excel to create UPC barcodes, Code 128 barcodes, Interleaved 2 of 5 barcodes, POSTNET barcodes, and Code 39 barcodes right in your spreadsheets.

It’s an easy two-step process to make barcodes using Excel:

You cannot simply input a chunk of text in a bar code font and expect to create a scannable barcode symbol. We make it simple by including sample code with all of Azalea’s products to help you integrate our fonts in your Excel spreadsheet. Our sample code adds start and stop bars, calculates any necessary check digit(s), and encodes the output into our character set to make a barcode. This means that any bar code you create will be scannable; our software does the conversion for you. You can also use Access, Word, CrystalReports, C++, and Visual basic to make barcodes, too; it’s not just Excel.

To use our Excel function, download AzaleaBarCodes.xla into your XLStart directory (Program Files\Microsoft Office\OFFICE11\XLSTART). On 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 under the “user defined” functions in Excel.