Home: Products: Barcode Integration Guide for Microsoft Excel:

Barcode Integration Guide for Microsoft® Excel®

IDAutomation provides several professional-grade products for implementing barcodes in Microsoft® Excel®, including the Office 2007 version, with flexible license agreements to meet a variety of needs including small company licenses and royalty-free developer licenses. The following chart may be used to determine the best product needed:

Type of Integration Desired with Tutorials and Product Links	Compatibility	Base Price
Easily create barcodes in Excel cells or columns with Self-Checking Barcode Fonts; Use Codabar Fonts (for numbers only) or Code 39 Barcode Fonts (for numbers and/or uppercase letters).		$99 USD* CAD GPB
Create an entire column of barcodes in Excel using the smallest barcode type by integrating Microsoft® Visual Basic® Macros for Excel with the Interleaved 2 of 5 Fonts (for even numbers only) or the Code 128 Fonts (for numbers and/or text). Other barcode font types are also supported, including UPC/EAN and MSI.	**	$139 USD* CAD GPB
Create an entire column of barcodes in Excel, using a Macintosh or in a Microsoft® Windows® Double Byte Environment by integrating the Native VBA Macros with the Universal Barcode Font.		$199 USD* CAD GPB
Print barcode labels from data in Excel using the IDAutomation Barcode Label Software.		$139 USD* CAD GPB
Create and paste static barcode images into Excel with the IDAutomation Barcode Image Generator.		$99 USD* CAD GPB
Create a barcode in a single cell from data in another cell with the IDAutomation Barcode ActiveX Control.		$199 USD* CAD GPB
Combine multiple fields into a single barcode with the Codabar Fonts (for numbers only) or Code 39 Fonts (for numbers and/or uppercase letters).		$139 USD* CAD GPB
Use Excel as the data source for a Microsoft® Word mail-merge. Watch our How to create a barcode in Excel video.	**	$139 USD* CAD GPB
Scanning Barcodes into Excel	Compatibility	Base Price
Barcodes may be easily scanned into cells with a scanner or wand. In addition, tabs and returns may be encoded in the barcode to automate data entry. The following products are recommended: The IDAutomation USB Barcode Scanner is an easier to use, hand-held device that reads symbols instantly by aiming the unit and pulling the trigger. The IDAutomation Wireless Barcode Scanner is a light-weight cordless scanner with BlueTooth technology allowing readability up to 50' away from cradle.		Starting at $119 USD CAD GPB
* The Single User License is only for the use of 1 user on 1 computer. Please read section 1 of the License Agreement to determine if additional licenses are needed. If printing to a printer that prints more than 55 pages per minute, at least 1 Developer License is required. Price quoted does not include optional Priority Support. ** When using Code 128 or Interleaved 2 of 5 barcode fonts on the Macintosh or outside of the USA in Microsoft® Windows®, IDAutomation recommends using the Universal Barcode Font with the Native VBA Module provided with that package.

Barcode Tutorial for Excel
To use barcode fonts other than the self-checking versions, please refer to the tutorials at the Microsoft® Office® Macros site.
If assistance is needed, please contact IDAutomation.

© Copyright 2005-2009 IDAutomation.com, Inc., All Rights Reserved. Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries. Additional Legal Notices.

Over 70% of Fortune 100 companies use IDAutomation's products to automate their businesses.