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