Barcode Fonts, Components, ActiveX and .NET Windows Forms Controls, Java Servlets, 
DLLs and Barcode Scanners. IDAutomation.com, Inc., Computers Hardware, Software & Services, Tampa, FLThis site chose the Norton Secured Seal to promote trust online with consumers. View your cart in the IDAutomation Store


Home > Barcode Components > Native Barcode Generator for Microsoft Excel > User Manual:

Native Barcode Generator for Excel

Order Native Barcode Generator for MS Excel Download Demo for Native Barcode Generator for MS Excel View most recent updates to the Excel Native Generator Forum support for Native Barcode Generator for MS Excel

Native Barcode Integration

Native barcode integration embeds the VBA macros directly into the Excel file, so that even when it is distributed, the spreadsheet will still be able to generate barcodes.

  1. Extract the files from the Excel Native Barcode Generator package.
  2. A working example is provided in each package and may be referred to if needed.
  3. Open the Spreadsheet where the barcode is needed.
  4. Press ALT-F11 (Mac users choose Option-F11) to open the Visual Basic Editor. If ALT-F11 does not work, choose Developer - Visual Basic.
    The Excel Visual Basic Editor
  5. From the Visual Basic Editor, choose File - Import File and import the appropriate module from the VBA folder of the files extracted. Once the files are imported, they become embedded in the Spreadsheet file.
    The VBA editor in Excel for Code 128.
  6. Choose File - Save and then close the Visual Basic Editor. All functions of the chosen module are now embedded in the Spreadsheet.
    Note: It is suggested to save the spreadsheet immediately as an Excel Macro-Enabled Workbook (XLSM) to ready the file for distribution.
    Save As Macro Enabled
  7. Generating the Barcode:
    Size the cell that will contain the barcode symbol so there is enough space to contain it. The size of the barcode will be generated to fit within the cell. If entire columns or rows need to contain barcodes, select the entire rows or columns and size these appropriately.
    Sizing multiple cells in Excel
    NOTE: If multiple cells will contain barcode symbols, do not use the ImageType of "2" because it can take Excel a long time to draw shape symbols.
  8. Enter the formula for example: =IDAutomation_NXLS_Code128(A3) in the cell that will contain the barcode image and verify the size is correct. Only the cell reference is required; all other properties are optional. Once the image is generated it may have to be deleted to gain access to the formula in the cell, which resides behind the image.
    The formula in the cell that will contain the barcode.
    If it is desired to have the text interpretation below the barcode symbol, use the function ending in HR. All functions ending in HR automatically return a BMP image.
    Text interpretation below the barcode symbol in Excel.
  9. If multiple cells are to contain barcodes, perform the following:
    1. Delete the barcode image from a cell that correctly generates the barcode symbol.
      Selecting the cell image
    2. Click on that cell and choose Copy.
      Copying the Excel formula
    3. Click on the other cells that are to contain barcodes and choose Paste, then return to the original copied cell and hit Enter. It may take some time for the images to be generated depending on the about of data being encoded and the number of cells.
       
  10. Scan the barcode to ensure the image is generated correctly.
  11. If the cells are resized and the images need to be regenerated, DataToEncode will need to be changed. Changing the formula to encode nothing, for example =IDAutomation_NXLS_C128("") will remove the barcode image from the cell.

Barcode Add-In Integration

Excel Add-In Integration adds barcode generation functionality for a particular user or computer. If the spreadsheet is distributed, Native Barcode Integration is recommended. The addin must be installed and then activated before it will function.

  1. Extract the files from the Excel Native Barcode Generator package.
  2. Open the appropriate file ending in xlsm from the files extracted.
  3. Choose File - Save as and select Excel Add-in (*.xlam).
    Saving the Excel Add-in.
    Note: for Excel 2003 the option will be (*.xla) instead of (*.xlam).
  4. Choose save. The add-in is now installed for the current user. To install it for all users on a computer, shut down Excel and move the add-in file from %appdata%\Microsoft\Addins, (where %appdata% is the system shortcut for the userís profile (roaming) folder) to the appropriate ADDINS folder within Program Files. For example, Excel 2010 addins are stored in \Program Files\Microsoft Office\Office14\ADDINS\ .
  5. After the addin is installed, it must be activated. Activate the addin for use in Excel by using Excelís addin manager (File > Options > Add-ins > Manage add-ins).
  6. Open the Spreadsheet where the barcode is needed and follow the steps above from step 6, Generating the Barcode.

Functions | Formulas

The formula used in step 7 of this tutorial may be altered to generate different barcode types and change options, which are listed below. Only DataToEncode is required; all other properties are optional. For example, to create a Code 128 barcode from the data in cell A3, the formula would be:
 =IDAutomation_NXLS_C128(A3)

Alternatively, to change the options to generate a BMP image, the formula would be:
 =IDAutomation_NXLS_C128(A3,1)

To generate a BMP image with the text interpretation below the barcode, the formula would be:
 =IDAutomation_NXLS_C128HR(A3)

Linear Symbologies
IDAutomation_NXLS_C128 (DataToEncode, ImageType, ApplyTilde, QuietZone) (ApplyTilde is automatically set to True in this function)
IDAutomation_NXLS_C128HR (DataToEncode, ApplyTilde, QuietZone) (ApplyTilde is automatically set to True in this function)
IDAutomation_NXLS_C128A(DataToEncode, ImageType, QuietZone)
IDAutomation_NXLS_C128AHR(DataToEncode, QuietZone)
IDAutomation_NXLS_C128B(DataToEncode, ImageType, QuietZone)
IDAutomation_NXLS_C128BHR(DataToEncode, QuietZone)
IDAutomation_NXLS_C128C(DataToEncode, ImageType, QuietZone)
IDAutomation_NXLS_C128CHR(DataToEncode, QuietZone)
IDAutomation_NXLS_C39(DataToEncode, ImageType, N_Dimension, IncludeCheckDigit, QuietZone)
IDAutomation_NXLS_C39HR(DataToEncode, N_Dimension, IncludeCheckDigit, CheckCharacterInText, QuietZone)
IDAutomation_NXLS_C93(DataToEncode, ImageType, QuietZone)
IDAutomation_NXLS_C93HR(DataToEncode, CheckCharacterInText, QuietZone)
IDAutomation_NXLS_Codabar(DataToEncode, ImageType, QuietZone, StartChar, StopChar)
IDAutomation_NXLS_CodabarHR(DataToEncode, StartChar, StopChar, QuietZone)
IDAutomation_NXLS_EAN13(DataToEncode, ImageType) (This function only returns image types 1 and 3 by design)
IDAutomation_NXLS_I2of5(DataToEncode, ImageType, N_Dimension, IncludeCheckDigit, QuietZone)
IDAutomation_NXLS_I2of5HR(DataToEncode, N_Dimension, IncludeCheckDigit, CheckCharacterInText, QuietZone)
IDAutomation_NXLS_MSI(DataToEncode, ImageType, N_Dimension, IncludeCheckDigit, QuietZone)
IDAutomation_NXLS_MSIHR(DataToEncode, N_Dimension, IncludeCheckDigit, CheckCharacterInText, QuietZone)
IDAutomation_NXLS_IMb(DataToEncode, ImageType, QuietZone)
IDAutomation_NXLS_Postnet(DataToEncode, ImageType, IncludeCheckDigit, QuietZone)
IDAutomation_NXLS_Planet(DataToEncode, ImageType, IncludeCheckDigit, QuietZone)
IDAutomation_NXLS_UPCA(DataToEncode, ImageType) (This function only returns image types 1 and 3 by design)
2D Symbologies
IDAutomation_NXLS_DataMatrix(DataToEncode, ImageType, ApplyTilde, EncodingMode, PreferredFormat, QuietZone)
(ApplyTilde is automatically set to True in this function)
IDAutomation_NXLS_PDF417(DataToEncode, ImageType, EccLevel, ColumnSpecifyRowSpecify, Truncate, ForceBinary, QuietZone)
(ApplyTilde is automatically set to True in this function; to disable, refer to the documentation in the VBA code)
IDAutomation_NXLS_QRCode(DataToEncode, ImageType, ApplyTilde, EncodingMode, ErrorCorrectionLevel, Version, ProcessMask, NewLineCharacter, QuietZone)
Example: =IDAutomation_NXLS_QRCode("www.idautomation.com",1,,,,,,,8) returns an image type of 1 (BMP) with a QuietZone of 8.
(ApplyTilde is automatically set to True in this function)
Common Properties:

Support & Troubleshooting

Forum support for Native Barcode Generator for MS Excel
View most recent updates to the Excel Native Generator
Common Problems and Solutions:
  1. Cross-platform Issues: When transferring a spreadsheet containing a 2D symbol from Windows to Mac, an image may loose its shape and appear slightly more rectangle which may cause scanner errors. Selecting the image type of 1 (BMP) may resolve the issue.
  2. Image Resize or Removal: If the cells are resized and the images need to be regenerated, DataToEncode will need to be changed. Changing the formula to encode nothing, for example =IDAutomation_NXLS_C128("") will remove the barcode image from the cell.
  3. X dimension: Because the symbols generated form this product are designed to fit within their respective cells, the X dimension will have to be determined by adjusting the size of the cell and performing a visual comparison with one of the IDAutomation Barcode Creators using the same data. Additionally, many barcode verifiers including the IDAutomation 2D scanner with PQA can also determine the X dimension.
  4. Image Refresh: Changing properties may not always cause the barcode image to be updated. By design, the image is only updated when the DataToEncode changes.
  5. Transparent Background: By default the background color of all images is white. EPS and shape images can be changed to transparent by locating the following statement in the VBA and changing it to true:
    Const BackgroundTransparent As Boolean = False

Additional problems and solutions are provided in public support forum threads. Priority phone, email and forum support are provided up to 30 days after purchase. Additional priority phone, email and forum support may be obtained if the Level 2 Support and Upgrade Subscription is active.

Back to Top

 ©Copyright 2017 IDAutomation.com, All Rights Reserved. Legal Notices.

 Barcode Fonts | Components | Scanners | Support | Contact Us

Loading
Training Videos on YouTube  Join us on Google Plus  Join us on LinkedIn  Follow us on Twitter  Like us on Facebook
Over 70% of Fortune 100 companies use IDAutomation's products to automate their businesses.