upc version A, upc version E, isbn-13, ean-13, ean-8, jan bar codes
Printing UPC, ISBN-13, EAN, and JAN bar codes in Excel spreadsheets is extremely easy. Create UPC, ISSN-13, EAN, and JAN barcodes with our Excel macros. Our macros convert your existing spreadsheet data into scannable barcodes.
UPCTools comes with a set of macros that convert your data into barcodes by adding the guard bars, calculating the check digit, and mapping the output into our fonts' character set. Pass your data into the macro and format the macro's output in our UPC fonts. Your data in, barcode out.
Macros and User Defined Functions for Excel 2003 & 2007:
The macros above are the easiest and fastest way to use UPCTools and Excel. They're straightforward and self contained. The sample spreadsheets have plenty of comments in them that explain how they work. Feel free to copy them into your own spreadsheets.
We also offer a plug-in for Excel that calls our DLL. The macro in the spreadsheet is self-documenting because it is designed to be simple and direct, and there are comments in the spreadsheet and the macro itself. Below are instructions for using the plug-in and DLL.
UPCTools' installer automatically places the files you need in the appropriate folders for you. If you need to do it manually yourself, place AzaleaBarCodes.xla into your XLSTART directory (Program Files\Microsoft Office\OFFICE11\XLSTART or OFFICE12\XLSTART) and put barcode.dll into either your \WINDOWS\SYSTEM32 or \WINNT\SYSTEM32 directory.
Open your Excel spreadsheet. The data to be converted into a UPC barcode will be in one column. Enter your 11-digit UPC number (your company prefix + your item number) into Column A.
Pick the cell that you want to contain the bar code symbol; in this case, we’ll use B1. Type the equal sign “=”.
The available functions drop down list opens (black arrow above A1 cell). You can also get to these functions by choosing Format>Insert Function from the menu.
You want to choose “More functions;” this will make another window pop open. Pick “User defined,” which will make Azalea’s UPC functions appear. Select “AzaleaUPC_A” or whatever type of bar code you need. Click the OK button.
You’ll see a box called “Function Arguments” You just need to input the cell location that has the data you want to make into a UPC; in our case, that’s the content of cell A1. Click the OK button.
Select B1. Choose the “Format” menu, pick “Cell” then click the “Font” tab. Select a UPC font and point size (73 points for a full-sized symbol. Your symbol must be at least 60 points to be a scannable UPC barcode.
It’s a good idea to center the barcode in the cell. To do so, click the “Alignment” tab and choose Center for both horizontal and vertical.
Your completed barcode project should look like this. It’s time to print our barcodes!
Select A1-A4 and B1-B4. Choose “File” and then Print and Preview from the menu. Once you’re ready to print your barcodes, press “Print.”
Need help? Email us at azalea at azalea dot com or call 1.206.341.9500
