Sending ZPL via VBA (Visual Basic for Applications)

Article ID: 06599497

Issue / Question

Customer want develop a VBA program in Excel, that can send ZPL to printer.

Applicable To

All ZPL-based barcode printers. 

(does not apply to KR203, ZQ110, EM220 and EM220II)

Resolution / Answer

1. Add a Generic / Text Only printer.

2. Set the printer as default printer.

3. Programming in VBA IDE (Visual Basic (for Application) / Integrated Development Environment) , save the command script into a text file.

4. Programming in VBA IDE, recall the "notepad.exe" to print the text file to default printer.

+ Applicable Products

  • 105SLPlus Industrial Printers
  • 110PAX Print Engines (disc.)
  • 110Xi4 Industrial Printer
  • 140Xi4
  • 140Xi4 Industrial Printer
  • 170PAX4
  • 170Xi4 Industrial Printer
  • 220Xi4 Industrial Printer
  • 2824-Z Series
  • EZ320 Mobile Printers
  • Food Safe Card Solution
  • GC420d Desktop Printer
  • GC420t Desktop Printer
  • GK420d Desktop Printer
  • GK420d Healthcare Desktop Printer
  • GK420e
  • GK420t Desktop Printer
  • GK420t Healthcare Desktop Printer
  • GK888d
  • GK888t
  • GX420Rx Desktop Printer
  • GX420d Desktop Printer
  • GX420t Desktop Printer
  • GX430d Desktop Printer
  • GX430t Desktop Printer
  • HC100 Wristband Printer
  • KR403 Kiosk Receipt Printer
  • LP 2824 Plus Desktop Printer
  • MZ-220
  • MZ-320
  • P100i
  • P110i
  • P110m
  • P110m
  • P120i
  • P330i Card Printer
  • P430i Card Printer
  • P4T Mobile Printers
  • P630i Card Printer
  • P640i Card Printer
  • QL320 Mobile Printer
  • QL420 Mobile Printer
  • QLn220 Healthcare
  • QLn220 Mobile Printer
  • QLn320 Healthcare
  • QLn320 Mobile Printer
  • QLn420 Mobile Printer
  • QuikCard ID Standard Solution Bundles
  • QuikCard Professional Solution Bundles
  • RW 220 Mobile Printer
  • RW 420 Mobile Printer
  • RW 420 Print Station
  • S4M
  • TLP 2824Plus Desktop Printer
  • TTP 2000 Series Kiosk Receipt Printers
  • TTP 2110 Kiosk Printer
  • TTP 2130 Kiosk Printer
  • TTP 7030 Kiosk Receipt Printer
  • TTP 8200 Kiosk Printer
  • TTP 8300 Kiosk Printer
  • ZC100
  • ZC10L Card Printer
  • ZC150
  • ZC300-LA-APAC
  • ZC300-NA-EMEA
  • ZC350
  • ZD410-HC
  • ZD410D
  • ZD420-D-T
  • ZD420-D-T-HC
  • ZD420-HC
  • ZD420C
  • ZD420D
  • ZD420D-HC
  • ZD420T
  • ZD500 Desktop Printer
  • ZE500 Print Engines
  • ZM400
  • ZM600
  • ZQ120
  • ZQ220
  • ZQ300 Series Inside
  • ZQ300 Series Outside
  • ZQ310
  • ZQ320
  • ZQ510 Mobile Printer
  • ZQ520 Mobile Printer
  • ZQ610
  • ZQ610-HC
  • ZQ620
  • ZQ620-HC
  • ZR128 Mobile Printers
  • ZR138
  • ZR300 Series Mobile Printers
  • ZR318 Mobile Printers
  • ZR328 Mobile Printers
  • ZR338 Mobile Printers
  • ZR600 Series Healthcare Mobile Printers
  • ZR628
  • ZR658
  • ZR658-HC
  • ZR668
  • ZR668-HC
  • ZT210 Industrial Printer
  • ZT220 Industrial Printer
  • ZT230 Industrial Printer
  • ZT410 Industrial Printer
  • ZT420 Industrial Printer
  • ZT510 Industrial Printer
  • ZT600 Series Industrial Printers
  • ZT610 Industrial Printer
  • ZT620 Industrial Printer
  • ZXP Series 1 Standard Card Printers
  • ZXP Series 3 Card Printers
  • ZXP Series 3 with Security Enclosures
  • ZXP Series 3C Card Printers (China Only)
  • ZXP Series 7 Card Printer
  • ZXP Series 7 Pro High Performance Card Printers
  • ZXP Series 7 with Laminator
  • ZXP Series 8 Card Printer
  • ZXP Series 8 Secure Issuance Card Printer
  • iMZ220 Mobile Printer
  • iMZ320 Mobile Printer