VBA - Printer Properties - Duplex

 Hi Everybody

Is there a way of setting the printer properties to Duplex (Double Sided) by using VBA.

I would like to set duplex on all Worksheets(100+) by using VBA as it seems there is no other way to do it, other than to do each sheet one at a time.

Hope there is a way. Any workarounds?

Thanks for your time.
Kind regards
Ian Smith

Ian

Does sheet grouping and then printing as one job not work?

Click on first worksheet tab and then hold shift key down and click on the last. Anthing you do to these grouped sheets should happen to them all?

If not you may be stuck with VBA as that only works with the page setup dialog not the printer setup dialog which is provided by the printer driver.

If this doesn't work, does anyone know if XL4 (XLM) code will do it? (before my time)

 Hi Nick

Thank for replys. I am afraid that selecting multiple worksheets does not help and only the worksheet in the front is affected. I was very surprised by this.

This is okay if you only have a few worksheets to print but not fun when you have about 100 or so.

Very time consuming.

Regards

Ian

Ian,

I found the same problem with xl 2003 using a network printer. Printer settings cannont be easily transferred across multiple sheets. Is it possible that the print driver is at-fault, or the XL interface to the print driver? We are using a (relatively) sophisticated Ricoh printer that does duplex, stapling, etc.

Alex J

 What we had to do in a similar situation was set up a separate printer driver (it pointed to the same printer as the 'normal' driver) that had the specific options selected as the 'default'.  For example, we set up a driver that had duplexing turned on, and called the printer something like 'Rico 2175 Duplex'.  You can then use this as the printer for the Excel jobs, and they will automatically be duplexed.

Hope this helps!

 Hi Pgmer

Thanks, I see what you are doing and will give it a go when I am on that site tomorrow and update.

Cheers

Ian