code set A, code set B, code set C, and GS1-128 bar codes
Making Code 128 bar codes in Excel spreadsheets is really easy. Create Code 128 barcodes using our Excel macros. The macros convert the data in your spreadsheet into a scannable Code 128 barcode including code set A, code set B, code set C, and GS1-128 symbols.
C128Tools comes with a set of macros that add the necessary start and stop bars to your input string, calculates the mod 103 check digit, and maps the result into our fonts' character set. All you have to do is format the returned string in our Code 128 fonts. Pass your data in, format the output in our fonts.
Macros and User Defined Functions for Excel 2003 & 2007:
The macros above are the easiest and fastest way to use C128Tools and Excel. They're straightforward and self contained. The sample spreadsheets have plenty of comments in them to show you how they work. Feel free to copy them to your 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.
C128Tools' 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 Code 128 barcode will be in one column,. In this example, our "input data" column is Column A.
Choose the cell you want to contain the bar code symbol; in our case, we’ll use cell B1. Type the equal sign “=”.
The drop-down list with your available functions will become active (black arrow above A1 cell). You can also do this by going to the menu and choosing “Insert” and then “Function.”
Choose “More functions” and another window will pop open. Choose “User defined” (meaning, in this sample, the list of available functions within your XLSTART directory add-in’s). Azalea’s Code 128 functions appear. Select “AzaleaCode128A”, “AzaleaCode128B”, or “AzaleaCode128C” depending on which code set your data requires.
Click the OK button.
You’ll get a “Function Arguments” window. This just means the cell you mean to translate into an Azalea Code 128 barcode. In this sample, we’re using cell A1. Click the OK button.
Choose B1, where there’s a string of text. Go to the “Format” menu, choose “Cell” then click the “Font” tab. Select a Code 128 font and point size.
You should center the barcode, too; to do so, click the “Alignment” tab and choose Center for both horizontal and vertical.
...select Edit/Fill/Down or press Ctrl+Enter to copy the formula to all the cells underneath.
Select A1-A4 and B1-B4; choose File, Print and then Preview. Your print preview willcome up and it should look like this. Once you’re ready to print your barcodes, press “Print.” If the output result differs or you see boxes or odd characters in the preview, please send a screenshot to technicalsupport at azalea dot com and we’ll be happy to help you get it sorted out.
Need help? Email us at azalea at azalea dot com or call 1.206.341.9500
