Skip to main content

Install In Excel For Windows

Use this path when the scanner writes directly into Microsoft Excel on Windows.

Requirements​

  • Microsoft Excel for Windows with macros enabled.
  • The single VBA module file: ParseEncodedString.bas.
  • A macro-enabled workbook (.xlsm).

The module is pure VBA. It does not require ActiveX references or VBScript.RegExp.

Use ParseEncodedString.bas for import. Excel's VBA file browser expects .bas for standard modules.

You do not need to download the full repository for Excel use. Download only ParseEncodedString.bas. If your browser saves it as ParseEncodedString.bas.txt, rename it to ParseEncodedString.bas before importing.

Import The VBA Module​

  1. Open Excel.
  2. Create or open the workbook where the scanner will write codes.
  3. Save it as an Excel Macro-Enabled Workbook (.xlsm).
  4. Download ParseEncodedString.bas.
  5. Press Alt+F11 to open the Visual Basic editor.
  6. Open Project Explorer with View > Project Explorer if the project tree is not visible.
  7. In Project Explorer, select VBAProject (your-workbook-name.xlsm).
  8. Use File > Import File... and select the downloaded ParseEncodedString.bas.
  9. If you do not see Import File..., right-click the workbook project or the Modules folder in Project Explorer and choose Import File....
  10. Confirm that a module named DataMatrix2CodesModule appears under Modules.
  11. Save the workbook.
Synthetic Windows Excel workbook showing imported VBA module and status-colored scanner results
Synthetic Windows Excel setup. No real product or serial data is shown.

Next Step​

After the module is imported, follow Excel Quick Start. That page covers the scanner workflow, including when to run DataMatrix2Codes.

Macro Security​

If Excel opens the workbook in Protected View, enable editing and enable macros only for workbooks you trust. If Windows blocks the file because it came from the internet, unblock it from the file properties dialog or place it in a trusted location approved by your organization.

If Import Is Still Hidden​

Use the manual fallback:

  1. In the Visual Basic editor, use Insert > Module.
  2. Open macro/ParseEncodedString.bas in Notepad or another text editor.
  3. Copy the code from Option Explicit downward into the new module. Skip the first Attribute VB_Name = ... line when pasting manually.
  4. Save the workbook as .xlsm.

Validate The Module​

Run RunDataMatrixSelfTest after importing the module. A passing result means the Excel implementation matches the current fixture behavior.