How to create a Barcode add-in for Excel

< Back
You are here:

How to create a Barcode add-in for Excel

*This Barcode Addin is only compatible with Office 2010 and earlier.


This set up will allow the ability to add the IDAutomation VBA Code and Barcode Macros as an add-in for Excel so the IDAutomation Barcode Macro functions will automatically be available every time a spreadsheet is created.

How to create a barcode add-in for Excel:
  1. Most recent versions of Excel require a medium security setting to run macros. Open Excel and set the security level to medium by choosing Tools – Macro – Security.
  2. If a spreadsheet is used that is different from the sample IDAutomation provides, import the macro into the spreadsheet.
  3. Once imported, go to the File menu and select Save As.
  4. In the “Save as Type” drop-down list, choose “Microsoft Office Excel Add-In”; give the file a descriptive name such as IDAutomation Barcode and click Save.
  5. Close this workbook and open a new one.
  6. Go to the Tools menu and select Add-Ins
  7. A list of the Add-Ins should appear.
  8. Check the box of the add-in created earlier, called IDAutomation Barcode in this example.
  9. Now the barcode functions of the macro may be called in every spreadsheet without the need to import it each time. For example:
    Excel Formula

For information about other methods of Excel barcode creation, please refer to the Excel Barcode FAQ & Tutorial.