How to setup a program to print on lower bin tray

[Guest]

I recorded a macro, but it did not include lower bin (tray 2) in the page
setup sequence.
Is there a way to set this program for a particular worksheet?

Thanks,

 

[Tom Ogilvy]

VBA does not provide any direct support for selecting the Tray on a printer.

You would have to use the Windows API I believe or perhaps define a separate
print driver that uses tray 2.

 

[Jason Morin]

Sendkeys is an option although many say it's unreliable
and should be avoided. The Microsoft KB has an article
that addresses your problem:

Changing the Paper Source Using SendKeys:
http://support.microsoft.com/default.aspx?scid=135791

HTH
Jason
Atlanta, GA

 

[Don Guillett]

Set up TWO printers, 1 with one tray, another with the other.