Do not print in duplex

[Jos Vens]

Hi,

we have a new copier/printer from Nashuatec. To save paper, the printer
always prints in duplex (recto/verso). I was wondering if it is possible to
override this and set it up to print only on one side. I was looking in the
properties of excel but it don't find anything. I can set other things like
this:

spRapport.PageSetup.CenterHorizontally = True
spRapport.PageSetup.CenterVertically = False
spRapport.PageSetup.Orientation = xlLandscape
spRapport.PageSetup.BlackAndWhite = False
spRapport.PageSetup.PaperSize = xlPaperA4
spRapport.PageSetup.Zoom = False
spRapport.PageSetup.FitToPagesWide = 1
spRapport.PageSetup.FitToPagesTall = 1

I'd like to set:

spRapport.PageSetup.Duplex = False

or something like that (the printerdriver can do this, but can excel?)

thanks,
Jos Vens

 

[Tom Ogilvy]

http://groups.google.com/[email protected]

See Dana's link to the word article and Dave Peterson's suggestion (which is
simpler if it is just for you).

 

[Jos Vens]

Thanks Tom,

I thought it wouldn't be as easy as setting a standard feature like I did
before!

Greetings,
Jos Vens