change printer settings

trevorc · #1 07-16-2020, 09:21 PM

Hi All,
I've been trying to change some printer settings and so far have been successful, until needing to change the page size. This is for a small label printer the labels are 100mm x 50mm this keeps defaulting to the printer defaults and i cannot change them permanently for some reason i don't know,.
I can select the correct printer with this line of the code

Code:

Application.ActivePrinter = "\\U2-front-desk\bixolon slp-d420 on Ne05:"

And this to change some settings

Code:

With ActiveSheet.PageSetup

I have seen this from Microsoft

HTML Code:

https://docs.microsoft.com/en-us/office/vba/api/Excel.XlPaperSize

but it doesn't list the size i need to set, anyone know how to add to this list or manually enter one into it?

Any ideas would be helpful thanks

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How do I lock printer paper size in Word docs saved to PDF?	bwofficer	Word	6	08-24-2017 12:30 AM
Can we NAME our own paper size that will show up on the printer?	FearlessStamper	Word	1	09-10-2016 03:23 PM
Exporting a Large Paper Size as a Single PDF Page	JamesEddy	Word	1	01-05-2016 11:23 AM
Custom page size settings	ibclare	Publisher	0	10-27-2014 08:34 PM
how change size font to inches size	kkepo	Word	4	08-28-2012 08:53 PM