98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Is it possible to create a Macro to Print Double sided and print
Is it possible to create a Macro to Print Double sided and print
Resolved · Medium Priority · Version 2010
Izabelle has attended:
Excel Intermediate course
Excel Advanced course
Is it possible to create a Macro to Print Double sided and print
We have an existing macro which prints the first page of our bill, including the back page (which sits to the side).
Here is the current macro, I need one which prints the Bill to tray 2, double sided and one that prints it to Tray 1 doubled sided.
Is this possible?
Thanks
Sub print1()
Application.ScreenUpdating = False
ActiveSheet.PrintOut From:=1, To:=2, Copies:=1, Collate:=True
End Sub
Sub print2()
Application.ScreenUpdating = False
ActiveSheet.PrintOut From:=1, To:=4, Copies:=1, Collate:=True
End Sub
Sub print3()
Application.ScreenUpdating = False
ActiveSheet.PrintOut From:=1, To:=6, Copies:=1, Collate:=True
End Sub
Sub print4()
Application.ScreenUpdating = False
Application.Dialogs(xlDialogPrint).Show
End Sub
RE: Is it possible to create a Macro to Print Double sided and p
Hi Izabelle
Thanks for getting in touch.
I hadn't come across this before but I checked online and unfortunately confirmed my suspicions. As 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.
Kind regards
Gary Fenn
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best 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
Wed 3 Oct 2012: 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:Shortcuts for working with named ranges in ExcelIf you are working with or creating named ranges in your spreadsheets, then you may find the following shortcut keys useful. |