Archive of Mr Excel Message Board

Back to Printing in Excel archive index
Back to archive home

Changing Printer Tray

Posted by Ryan on February 10, 2002 2:38 AM

Is there anyway of selecing the correct print tray when printing a doc using a macro? I have two tray printer and some docs need to go on letterhead where others go on plain. I have tried recording a tray change as part of the macro but nothing shows in the subsequent code. Thanks in advance.

I never sorted this by code set the default to Manual or top / bottom and them save, i had 2 Excel to do thsi then print.. Pain but only fix i worked out HTH [NT]

Posted by Jack in the UK on February 10, 2002 8:28 AM

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.