![]() |
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