Ida has attended:
Excel Intermediate course
Excel Advanced course
Excel VBA Intermediate course
Excel VBA Introduction course
Excel VBA double sided printing
HI,
How do i set a double sided printing via VBA? my default on my printer preferences is already double sided, but when my file is opened by another then goes back to me, and i print using vba as well-- it will print on just one side.
Thanks!
RE: Excel VBA double sided printing
Hi Ida,
Thank you for the forum question.
I have come across this question before. I checked online and unfortunately the printer options for duplex etc. are not set by Excel they fall outside of VBA'a control.
There might be a way to do accessing the printer's API but it would be fairly complicated, and would depend if the printer manufacturer has published the controls.
Sorry I couldn't be of more help on this occasion.
.
Please see link below.
https://www.ozgrid.com/forum/forum/help-forums/excel-general/37596-print-double-sided
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
RE: Excel VBA double sided printing
Hi Ida,
It can be coded in other languages (C#, C++, F#, and VB)
https://msdn.microsoft.com/en-us/library/microsoft.visualbasic.powerpacks.printing.compatibility.vb6.printer.duplex.aspx?cs-save-lang=1& ;cs-lang=csharp#code-snippet-1
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector