Printer Settings for a Zebra ZT230 Printer in VBA

Topic

New Reply

Hi Everyone,
I am trying to setup the page size on a Zebra ZT230 printer using VBA in Excel (Office 365)
I have tried recording a macro to see if that would capture the required coding for setting the page size, but alas, nope!
Can anyone point me in the direction of how I can set this?
On the attached picture, I have setup a “Select your printer” dialog, from which the user can select the required printer.
They can then set the properties of the printer (page size ect…).
But I wish to have the users avoid setting this every time they want to print out.
The settings do change for some reason, thus the need to code them in to the form.
plus the spreadsheet contains a number of different size labels that will be getting printed.
Thanks in advance for any help you can give me!
Regards
Brian.

Reply | Quote