code 39 and code 39 full ascii
Printing Code 39 bar codes in your Excel spreadsheets is really very easy. Create Code 39 barcodes using our Excel macros. The macros convert the data in your spreadsheet into a scannable Code 39 barcode.
C39Tools comes with a set of macros that add the necessary start and stop bars to your string. All you have to do is format the string the macro generates in our Code 39 fonts. The sample code makes standard Code 39 symbols as well as Code 39 Full ASCII. If you need to use the optional Code 39 check digit, we have a macro for that too.
The macros above are the easiest and fastest way to use C39Tools 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.
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.
C39Tools' 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.
We’ll assume that your input data is in the A column and that we want to create your barcodes in the B column. Type the equal sign "=" in cell B1.
The available functions drop down list becomes active (black arrow above A1 cell). You can alternately go your menu and select Insert and then Function.
Choose “More functions,” and a second window will pop open. Then choose “User defined” and Azalea’s Code 39 functions appear. Select “AzaleaCode39” or “Azalea Code39ASCII” as appropriate, then click the OK button.
Choose the cell that your data is in; in our example, it’s cell A1. Click OK.
Choose cell B1 and then Format>Cell>Font. Select an Azalea Code 39 font from the list and then set the point size.
It’s a good idea to center your barcode in the cell. To do so, click the “Alignment” tab and then Center for horizontal and perhaps vertical.
Then to copy our work over to all our cells in the B column, choose Edit>Fill>Down, or press shift-enter in cell B1.
Now it’s time to print our barcodes! In this case where we have four examples, select A1-A4 / B1-B4, and then File>Print>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
