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