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