Use UPCTools within Microsoft Excel to create UPC barcodes in your Excel spreadsheet. Our free sample code converts your input data into the equivalent UPC bar code.
It’s a two-part process: pass your data into our barcode macro and then format the returned value into one of our barcode fonts. The function adds the guard bars, calculates the necessary check digits, and maps the result into our fonts’ character set. You can not simply format a string in our fonts. It won’t have the correct format and will not work.
Macros and User Defined Functions for Excel 2003 & 2007:
The macro code & ReadMe for Excel 2004 (Mac):
We strongly recommend using the above sample files to get started. Suggestions and feedback are heartily encouraged.
Here are instructions on how to copy macros from one Excel spreadsheet to another.
