LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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!



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Default printer selection in Excel macro Charlie Excel Programming 1 April 3rd 06 10:16 PM
Printer Selection Hal[_4_] Excel Programming 1 November 18th 05 06:26 PM
Printer Selection Frank R Excel Discussion (Misc queries) 2 May 20th 05 04:31 PM
printer selection Craig Wilks[_2_] Excel Programming 1 October 1st 04 01:44 PM
Printer Selection Box Susan Lund Excel Programming 3 August 24th 04 06:41 PM


All times are GMT +1. The time now is 09:53 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"