barcode macro for upc, code 128, code 39, interleaved 2 of 5, postnet, & more
Printing barcodes in a spreadsheet is easy using our barcode fonts with the free macros we provide. All of Azalea's barcode font packages can print bar codes in Excel spreadsheets. Make UPC, ISBN-13, POSTNET, Code 128, Code 39, and other symbologies from your exiting data.
These Excel macros begin with your input data and then add the start and stop characters, calculates all of the check digits, and then maps into our fonts’ character set. You don’t have to learn how barcodes are built or how they work. Use our sample spreadsheets and everything is pre-built for you.
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: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.
If 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 for you to download and play with.
Email or call us if you have questions.
