macro to change from Activeprinter to other printer

[Sahak]

Hi all,

To change from Activeprinter to other printer (without showing Print Dialog), we use for example macro code:

 Application.ActivePrinter = "Brother HL-2170W series on Ne04:"

Or

 Application.ActivePrinter = "HP LaserJet P2035n Design on Ne03:"

In first code printer name is “ Brother HL-2170W series” & in second code printer name is “ LaserJet P2035n Design”, it is understandable, they are printers names, but how, or from where we can get “Ne04 in first code & “Ne03 in second code ?
Thank you in advance.

 

[Yongle]

Have a look at this which describes how to List Printers In VBA and how to select them
It does not answer your specific question but is a general solution to selecting printers

 

[Sahak]

Hi Yongle,

Thank you very much for reply.