View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 1,726
Default 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!