J
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
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