Code to Print to certain Printer
 

Is it possible via code to print to a certain printer?

The relevant printer is on a network

Thanks

Code to Print to certain Printer
 

Hi John

With VBA you can change the ActivePrinter and print the sheet.
And set it back to your default

You can change the ActivePrinter to the printer you want like this
Application.ActivePrinter = "hp officejet k series on Ne00:"

To know the names of your pinters
Change to it in the ctrl P dialog (Cancel after you choose the printer )
and run this so you know the name

Sub nameprinter()
MsgBox Application.ActivePrinter
End Sub

If you print with code then look also at Printout in the VBA help
You can fill in the name of the printer in the arguments


--
Regards Ron de Bruin
http://www.rondebruin.nl


"John" wrote in message ...
Is it possible via code to print to a certain printer?

The relevant printer is on a network

Thanks

Code to Print to certain Printer
 

Thanks Ron, helpful as always


"Ron de Bruin" wrote in message
...
Hi John

With VBA you can change the ActivePrinter and print the sheet.
And set it back to your default

You can change the ActivePrinter to the printer you want like this
Application.ActivePrinter = "hp officejet k series on Ne00:"

To know the names of your pinters
Change to it in the ctrl P dialog (Cancel after you choose the printer )
and run this so you know the name

Sub nameprinter()
MsgBox Application.ActivePrinter
End Sub

If you print with code then look also at Printout in the VBA help
You can fill in the name of the printer in the arguments


--
Regards Ron de Bruin
http://www.rondebruin.nl


"John" wrote in message
...
Is it possible via code to print to a certain printer?

The relevant printer is on a network

Thanks