98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Excel VBA double sided printing
Excel VBA double sided printing
Resolved · High Priority · Version 2010
Wed 19 Sep 2018, 11:08Delegate Ida said...
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!
Thu 20 Sep 2018, 09:06Trainer Jens said...
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
Thu 20 Sep 2018, 09:26Trainer Jens said...
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
Thu 27 Sep 2018: Automatically marked as resolved.
Training information:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Conditional formatting for cells that return text , not picked up by Go to commandIf you have tried to format all cells containing text even those that display text as a result of a formula you may have had difficulty. As Go to command with constant selected does not pick up formulas that result in text. |
