Programming duplex prints?

[Andrew Rowland]

I recorded a simple macro that automates printing to an A3 printer so i
could insert the code into another macro that i use. The macro recorded all
the printer settings that i changed except for the advanced option (under my
print options) of selecting duplex printing. Is there anyway to program
excel to use the duplex setting?
I know this probably dependent on my printer, however when i choose any of
the advanced options (when you select the printer and choose properties) the
macro doesnt recognise any settings i make.

TIA
Andy

[Dana DeLouis]

I am curious also. I did not find any ideas in any Ms Kb articles. I am
under the impression that Excel can not do this directly.
I found this one article, but still does not answer your Macro question.

XL2000: Only the First Worksheet Is Printed Duplex
http://support.microsoft.com/support/kb/articles/Q214/3/83.ASP

Ups... I just found an article written for Word. It uses some interesting
API calls.
This is a little over my head, but it does look interesting from an
"educational" point of view.
Maybe you will have faster luck then me.
Please let me know if you get it to work. HTH. Dana DeLouis.

(you would think it would be easier then this...???)

I wonder if you can use anything here to set a specific printer? This is
often asked here in the programming newsgroups.
I do not think there were any really good solutions found yet to my
knowledge...??

HOWTO: Set Duplex Printing for Word Automation

http://support.microsoft.com/support/kb/articles/Q230/7/43.asp

<short copy...>

Public Declare Function SetPrinter Lib "winspool.drv" Alias _
"SetPrinterA" (ByVal hPrinter As Long, ByVal Level As Long, _
pPrinter As Byte, ByVal Command As Long) As Long

' etc...

Public Function SetPrinterDuplex(ByVal sPrinterName As String, _
ByVal nDuplexSetting As Long) As Boolean

etc...
<end of copy>

"Andrew Rowland" <arow...@casey.co.uk> wrote in message
news:OnzR0WFhAHA.2096@tkmsftngp04...

[Dave Peterson]

Just another suggestion on top of Dana's:

Could you install another copy of the printer that you use and set its defaults
to duplex. Then you could change to that printer, print, and change back?

just a thought...

--

Dave Peterson
ea3...@msn.com