How to Print a Zebra label using Excel VBA?

// Expert user has replied.
S Scott Pelton 3 weeks 6 days ago
67 1 0


I currently have an Excel form that I use to print DYMO labels.  The VBA code goes out and finds the DYMO label format (.lwl file) and populates it with the data entered on the Excel form and then prints.  I would like to know if there is a way to print to the Zebra label format instead of the DYMO, as I haven't found one yet. 

Thanks for any help on this!

Please Register or Login to post a reply

1 Replies

S Steven Si

You can use the ZebraDesigner for Developers 3 to design a label template in ZPL. Then let your VBA code to find the variable values in the Excel and populate the values into the ZPL template. Then the VBA code sends the populated ZPL to the Zebra printer via the ZebraDesigner Windows Printer Driver, which can be downloaded from the printer's support page on website.

Can’t find what you’re looking for?