interleaved 2 of 5 & itf-14 bar codes
There are two ways to add Interleaved 2 of 5 barcodes to your Excel projects using I2of5Tools. We have a set of macros that adds the start and stop bars and creates text to formatted in our fonts.
Macros and User Defined Functions for Excel 2003 & 2007: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.
I2of5Tools' 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 Interleaved 2 of 5 barcode will be in one column,. In this example, our "input data" column is Column A.
Once you’ve done that, the available functions drop-down will become active (black arrow above A1 cell). Note that you also may do this and all following by going to Insert in the menu bar and then choose Function.
Choose “More functions” and a second window will pop up containing the “User defined” functions. You’ll see all of the Azalea functions; in this case we’re concerned with the I2of5 function; please select “AzaleaI2of5”. Click OK.
Provide the “argument”, which means your input cell. In our sample, it’s the content of cell A1. Click the OK button.
Choose the cell where the output is, in this case B1. Open the “Format” menu, pick the option for “Cell,” and then click the “Font” tab. Select an Azalea Interleaved2of5 font and choose your desired point size.
It’s a good idea to center the bar code; to do so, click the “Alignment” tab and choose Center for both horizontal and vertical.
Select Edit and then Fill and Down. You can also highlight the cell at the top of the column and press the Shift and Enter keys together.
Select A1-A4 / B1-B4 and then File, followed by Print and then Preview.
Your print preview will come 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
