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


Home > Barcode Scanners > 2D Imagers > SC7USB2D > PQA Capture Add-In for Excel

PQA WindowPQA Capture Add-In
Microsoft Excel 2007, 2010, and 2013

Download the Barcode Add-In for Microsoft Excel and Word in Windows and Macintosh

Before Installing the PQA Capture Add-In

Excel 2007 and 2010: No set up required before install.

Excel 2013: This add-in will not be visible unless  the following steps are completed.

Installing the PQA Capture Add-In

Excel 2007, 2010 and 2013 Users:

  1. Close any versions of Excel that are open
  2. Download and extract the IDAutomation_BarcodePQAExcelAddIn.zip file
  3. Navigate to where the above file was extracted
  4. Run IDAutomation_BarcodePQAExcelAddIn.exe -

    There may be Additional Components to install during setup (choose accept/ok/yes through similar items):

    Microsoft Additional ComponentsDownload bar screen

    After the components are installed, there will be a screen asking to install the "customization", which will be the Excel Add-In - select Install:

    Publisher cannot be verified popup

    If a certificate error screen is encountered, simply close and rerun IDAutomation_BarcodePQAExcelAddIn.exe:

    Certificate Trust Error
  5. Complete install:
    Sucessful Installation Confirmation
  6. This will enable the Add-In toolbar within Excel:
    Addin Toolbar
 

PQA Capture Add-In Tutorial

This tutorial will demonstrate how to capture Print Quality Assessment (PQA) data from the IDAutomation 2D Barcode Scanner directly into a Microsoft Excel 2007, 2010 or 2013 worksheet.

  1. Enable PQA (PQA can be enabled/disabled from Add-In or the User Manual)

    Enable Print Quality Assessment Feature for the IDAutomation 2D Barcode Imager

    Tip: When verifying barcode symbols with PQA, be sure to position the scanner directly over the barcode at an appropriate distance, such as 5 inches, as other angles or distances may incorrectly lower the grade in terms of height, width and gaps.

    IDAutomation 2D Barcode Scanner

  2. Select the cell to start capturing the PQA data:
    select cell 
  3. Press 'PQA Capture' on Excel's toolbar to have the Add-In window pop-up:
    Open PQA Addin Window
    • The 'Current Cell' is indicated on the top right to verify cell's current position. To re-position, close window, choose another cell, and restart Add-In.
    • Edit > Reset: Allows to reset data (including Enable PQA barcode)
    • Help > Online Tutorial: Brings up the information page.
    • Help > About: Gives development information and brings up IDAutomation's homepage when the logo is clicked.

    Note: Since the 2D scanner possesses its own buffer, the user is not limited to any time-restriction while scanning or restriction to staying at the computer. Simply follow the double-beep of the scanner to indicate a successful scan and that the next 2D barcode is ready to be scanned.

    IMPORTANT: While scanning data in, make sure not to click on anther program or the scanner will feed any remaining data into that other program.

  4. Start scanning in the barcode data into large text box. The user will see the PQA data being fed into the window while scanning. When the data has been read from the barcode, the Disable PQA barcode will then appear.
    Scanned PQA Data Window
    Although the Disable PQA barcode shows after the first line of data is processed, it is there only as a convenience. Disable PQA only when completely done and want to resume regular scanning.
  5. After the data is fed to the worksheet, the text box is cleared and the next cell down (in the same row) is chosen: PQA Data Transmitted to Excel
  6. When scanning complete, close window.

Disable 2D PQA

To go back to regular scanning, do not forget to disable PQA!

PQA Capture Add-In Technical Support

Common Issues

To reformat cell spacing for selected cells (with the Add-In window closed) - Go to Home Tab > Format > AutoFit Column Width:

Format Cell

<CR> = Carriage Return, AKA 'Enter Key' on a keyboard

<TAB> = Tab, AKA 'Tab Key' on a keyboard

<VT> = Vertical Tab, AKA 'Ctrl + K' on a keyboard

Normally, programs respond to these keys as commands. Their entries have been included in the data to give an accurate representation of the barcode.

To remove the above entries in the spreadsheet (with the Add-In window closed), select the cell(s) wanted to work in, press Ctrl + H, and indicate what to 'Find and Replace':

Find Replace Carriage Return

Product or Add-In support may be available by reviewing public forum threads. After the purchase of an IDAutomation SC7-USB-2D Scanner, Priority phone, email and forum support are provided up to 30 days. Additional priority phone, forum and email support may be obtained with an active Per Incident Support.

Back to Top

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

 Barcode Fonts | Components | Scanners | Support | Contact Us

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.