Specify Printer

  • Thread starter Thread starter Todd Huttenstine
  • Start date Start date
T

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
 
Hey please ignore this post. Was meant for
Excel.Programming.

Thanks
Todd Huttenstine
 
Back
Top