Printing a workbook with multiple style sheets

[gborka]

Hello
I have a workbook with many sheets. I would like to create a VB script that will print an array of sheets, but some are single sided and some are double sided (duplex).
I cannot find a command to define duplex printing
Thanks

 

[Chihiro]

Here read through the links.
http://www.vbforums.com/showthread.php?560964-Excel-VBA-Printing-Front-And-Back
http://www.vbforums.com/showthread.php?539074-Print-Macro-Information-Needed&p=3333608#post3333608

Basically, duplex is not provisioned in Excel. It's function in printer side. So you either have to use Send Keys or code posted in below link.

http://www.vbforums.com/showthread....r-shell-duplex-printing&p=3488633#post3488633