Click here to Skip to main content
14,870,685 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hello. Does someone know how to print an excel workbook with the option : Print on Both Sides ? I have a serious problem : once I open the saved template document on a machine, the option saved on template dissapears (the excel culture language is different). This is why I need to programmaticaly tell to the excelworkbook printing method to print on both sides. Thank you very much!
Posted

Im not sure if you can, that would have to be set in the printer dialog and not excel as some printers might not have the ability to print on both sides:
http://msdn.microsoft.com/en-us/library/microsoft.office.tools.excel.worksheet.printout%28v=vs.80%29.aspx[^]

But you can ofcource print it out as a PDF document, that it dosnt matter, as you can choose to print out on both sides afterwords in Adobe.
   
v2
Comments
Kenneth Haugland 31-Jul-12 7:39am
   
"The printer i'm using has the duplex value set to true.

You say that i should create a pdf document from the excel document and print the pdf document ?"

Im not sayinbg you shoud, but I dont think you can set it in excel. You'll have to set it in the printer dialog, and then the PrintOut function wont allow you to set it as far as I can see inb the documentation.
The printer i'm using has the duplex value set to true.

You say that i should create a pdf document from the excel document and print the pdf document ?
   

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900