Use C39Tools within Microsoft Excel to create Code 39 barcodes in your Excel spreadsheet. Our free sample code converts your input data into the equivalent Code 39 bar code.
Code 39 is unique among barcodes because all you need to do is add an asterisk before and after you input string and format it one of our fonts. This is because aterisk (*) is the start and stop bar. For example, *SAMPLE* scans as "SAMPLE". Without the asterisks, your barcode won’t scan.
barcodeString = "*" + yourInputString + "*"
Using our UFL is a two-part process: you pass a string into our macro and then format the returned string in one of our Code 39 barcode fonts. The macro adds the necessary start and stop bars for you. Changing the font alone won’t work. It won’t be a scannable symbol because it won’t have the start and stops bars nor the check digit. That’s what the macro does.
We strongly recommend using the above sample files to get started. Suggestions and feedback are heartily encourage.
Here are instructions on how to copy macros from one Excel spreadsheet to another.
