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:
- Use our XLA to encode your barcode
- format the output in one of our barcode fonts
- Code 128 barcodes in Excel
- Code 39 barcodes in Excel
- UPC barcodes in Excel
- Interleaved 2 of 5 barcodes in Excel
- POSTNET barcodes in 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.





