View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Todd huttenstine Todd huttenstine is offline
external usenet poster
 
Posts: 260
Default Specifiy Printer (Location/name)

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