ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Macro for printer selection (https://www.excelbanter.com/excel-programming/381201-re-macro-printer-selection.html)

Bob Phillips

Macro for printer selection
 
If you follow Tom's suggestion, you get the added bonus that you print
duplex from any application, so it is much more flexible.

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Tom Ogilvy" wrote in message
...
The easiest would be to install a second instance of the printer driver
and
configure it to print duplex (will appear as a separate printer). then
set
activeprinter to that "printer"

If you can't do that, then you are getting into code like this:

http://support.microsoft.com/default...b;en-us;230743

--
Regards,
Tom Ogilvy


"Valerie" wrote:

I have a macro for selecting a specific printer:
Application.ActivePrinter = "\\ussftw01\uspftw46 on Ne16:"

This printer is capable of printing duplex and has a setting specified as
duplex so how would I incorporate the duplex selection into this macro so
the
output is printed duplex automatically? It only prints single sided now.

Thanks!





All times are GMT +1. The time now is 05:12 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com