Uploaded March 2019 | Updated September 2026, 1 week ago

---

This IDAutomation video explains how to use the IDAutomation #VBA to format data in #Excel 2018 from Excel 2016 and prepare it for an InDesign data merge.

IDAutomation #Barcode 1D Fonts:
idautomation.com/barcode-fonts

#Code128 Barcode Fonts:
idautomation.com/barcode-fonts/code-128

How to Install Code 128 Fonts on Windows:
support.idautomation.com/Code-128/How-to-install-the-Code-128-Package-for-Windows/_1732


IDAutomation VBA download for 1D Fonts:
support.idautomation.com/Barcode-Fonts/How-to-download-and-import-the-IDAutomation-VBA-for-Excel/_1221

The IDAutomationVBA.bas formats data for Code 128, Interleaved 2 of 5, Code 39, UPCA, UPCE, EAN8, EAN13, and other 1D barcode types.


Code 128 uses the formulas:
=Code128() for Code 128 Auto
=Code128a() for Code 128A
=Code128b() for Code 12B
=Code128c() for Code 128C

Code 39 uses
=Code39()
=Code39Mod43()

Interleaved 2 of 5 uses
=I2of5()
=I2of5Mod10()

UPC/EAN use
=EAN8()
=EAN13()
=UPCA()
=UPCE()

VIEW PART 2 OF 2: This video explains how to perform a data merge using IDAutomation Encoded Data
youtu.be/eLJ6cLBVeFY