ZebraDesigner Essentials gives you the tools to: Quickly and easily design professional labels without prior knowledge of barcoding or labelling using our Microsoft Office-style interface. Value from the ActiveSheet.PrintOut statement the Zebra printer does not print a barcode but the appearance of the cell itself. ZebraDesigner Essentials software makes creating industry-standard and compliant labels simple, including fixed or variable data. However, this gives me an 'Run time error 1004 - Application-defined or Object-defined error' (which makes sense because Cell.Value is not an object) and if I remove the.

Understand this will link word with excel to print static text, if you want to do label serial numbers you will need an actual label program. The final part of this solution is to use these windows printer drivers from Seagull Scientific (pick the right one for your label printer). If Range('E' & r) '' Then 'the r values correspond with row numbersĪctiveSheet.PrintOut copies:=Range('A' & r).Value, collate:=True, IgnorePrintAreas:=False Use excel as your datasource and word as your label designer. It contains a 12-digit number to be printed as a barcode label: Sub ZEBRA_LABEL() This is not designed to work for as soon as the value is inputted, I was just testing to see whether the printer prints a BARCODE which is the most important part of this, so I used the code below which I lifted from here. I am looking for a macro or another way to print labels on a Zebra printer as soon as a value is inputted into a specific column in a spreadsheet. I am very much of a beginner with VBA so forgive any sloppiness.

Zebra label designer excel