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,
--
rcruz

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.

--
Regards,
Tom Ogilvy

"jrcruzr" wrote in message
...
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,
--
rcruz

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


-----Original Message-----
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,
--
rcruz
.

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

--
Don Guillett
SalesAid Software

"jrcruzr" wrote in message
...
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,
--
rcruz