Select a Printer Tray

[marwan hefnawy]

I used the senkeys method to show the built in dialog box "Print" then sends
6 repeated Tab keys to this dialog then sends one {Enter} to open the
printer's properties dialog box as following

Application.SendKeys "^{p}{Tab 6}~"

with the same manner I can continue to select the desired paper size and the
desired Tray.
But I think this is not the best way to select the printer Tray.
Do anyone knows a better Idea?
Thanks.

 

[Dave Peterson]

Can you install a second printer (same physical printer) that has this option
set.

Then you could just change printers when you want to use the other printer tray.

 

[Steve Garman]

Thats what I like to see.

Lateral thinking with the same attitude to resources that made Microsoft
great

 

[Dave Peterson]

If I were smarter, I'd know if this is a compliment or an insult. <vbg>

 

[Rob van Gelder]

I recall seeing Tray options in the PageSetup object. When I went to check
there were none. Tray options are in Word's PageSetup object, not Excel's.

If you used embedded objects in Word document it might work for you?