Specifiy Printer (Location/name)

[Todd Huttenstine]

Hey guys

Below is the code I use to print out a specific range:

Worksheets("Wkly Renewals").Range("D7:E" & RngCounter +
2).PrintOut

We have multiple printers in our building so how do I
specify what printer to print to? In this case I would
like to print to printer name 2CN. I know its IP address
as well. IP is 10.190.140.15:LP.


QUESTION 2:
Also is there anyway that I can list all the printers on
the network so I could then select the printer I wish to
use?


Thank you
Todd Huttenstine

 

[Frank Kabel]

Hi
for the second question I would use the build-in dialog with:
application.Dialogs(xlDialogPrint).Show