Generate Barcodes in Excel using Aeromium Barcode Fonts

TechnoRiver partners with Aeromium to resell its high quality and professional barcode fonts

The Aeromium barcode technology is implemented using TrueType fonts, and as such, allows barcodes to be treated as text in Excel and many other applications. This results in many advantages compared with graphics-based barcodes. For example, you could simultaneously change the size of multiple barcodes in a column of cells by selecting them and changing the font size.

Aeromium Barcode Fonts includes a complete set of Excel formulas for generating barcodes in Excel easily. These formulas will convert a raw data string into a format suitable for a barcode font.

Installing the Barcode Fonts Excel Formulas

For Excel 2002/2003

1. Launch Microsoft Excel.
2. Go to Tools > Add-Ins from the menu.
3. Click on the Browse button.
4. Navigate to the "formulas" directory ("C:\Program Files\Aeromium\formulas")
5. Select the "Aeromium Barcode Fonts.xla" Add-In file
6. Click on the OK button to install the add-in. You should be able see the dialog as below.

   

For Excel 2007

1. Launch Microsoft Excel.
2. Click on the Office Icon button.

   

3. Click on Excel Options.
4. In the Excel Options dialog, click the Add-Ins item.
5. Click the Browse button.
6. Navigate to the "formulas" directory ("C:\Program Files\Aeromium\formulas")
7. Select the "Aeromium Barcode Fonts.xla" Add-In file
8. Click on the OK button to install the Add-In. You should be able see the dialog as below.

   

Excel Security Settings

If you are having problems running Aeromium Excel Formulas, make sure you have setup Excel Security Settings properly.

1. Launch Microsoft Excel.
2. Click on Tools > Macro > Security
3. Set the security level to Medium

Using the Excel Formulas

Example Code 39 Barcode

1. Make sure the Aeromium Barcode Fonts package and Barcode Fonts Excel Add-In are properly installed as described above.
2. Launch Microsoft Excel.
3. In your Excel spreadsheet, key in the data "12345678" in cell A2.
4. The barcode will be created and placed in the adjacent column.
5. In cell B2, key in "=AeroCode39(A2)", and press the Enter key.
6. You will see the string "*12345678*" generated in cell B2.
7. Change the font of cell B2 to FontCode39H3. You can repeat the steps above for cell A3 and A4.

The example above shows the encodation of a Code 39 barcode. The Aeromium package includes many other formulas and fonts for different barcode symbologies. The table below provides a complete list.

Complete List of Barcode Excel Formulas

Back to Aeromium