I have a macro that prints to the manual feed tray. I
have the settings in the print setup to automatic select.
Is there a way via the macro to force Excel to print to
Tray 2 or whichever tray I want? I used the record new
macro and changed the paper source that way, but nothing
recorded in the macro. If not possible to force the tray,
is there any other around this.


Thanks.

Tim

You might try my addin MultiTrayPrint

it's not faultless yet.. but works on windows XP
in a local environment. i havent worked on it for a while,
but recently I got interested again due to some questions in this ng.

So I'd love to hear your experiences , comments, suggestions etc.
Be sure to mention your setup:
Windows and Excel version, Network? or Local printer.
and if network printer install type.

Be sure to save your work before giving it a whirl.
it lives next to the standard printdialog, with a RED printer on the
toolbar and in the menu.

It allows to print 1 page from tray1 and the rest from tray3
in 1 command.

Alternatives are difficult,
You'll have to open the PrinterDialog and use sendkeys.
fully hardcoded for your own PrinterStrings and PrinterDrivers.

You absolutely cannot record the changes you make in the printerdriver's
dialog.

hope to hear more..



keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"Tim Gwynn" wrote:

I have a macro that prints to the manual feed tray. I
have the settings in the print setup to automatic select.
Is there a way via the macro to force Excel to print to
Tray 2 or whichever tray I want? I used the record new
macro and changed the paper source that way, but nothing
recorded in the macro. If not possible to force the tray,
is there any other around this.


Thanks.

Tim

Hi Tim:

There is no way to do this through VBA. You would probably have to use the
Windows API to manipulate the Printer object.

Regards,

Vasant.

"Tim Gwynn" wrote in message
...
I have a macro that prints to the manual feed tray. I
have the settings in the print setup to automatic select.
Is there a way via the macro to force Excel to print to
Tray 2 or whichever tray I want? I used the record new
macro and changed the paper source that way, but nothing
recorded in the macro. If not possible to force the tray,
is there any other around this.


Thanks.

Tim