Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Default printer selection in Excel macro | Excel Programming | |||
Printer Selection | Excel Programming | |||
Printer Selection | Excel Discussion (Misc queries) | |||
printer selection | Excel Programming | |||
Printer Selection Box | Excel Programming |