Hello,

Can anyone tell me if it is possible, using VBA, to control on which tray
the printer must select the paper (when the printer has two or more paper
trays)????

Thanks a lot

Luc

Luc,

You cant in standard excel as you can in Word/Access and most other
apps.


I've seen some approaches using sendkeys but there not really flexible.

I've attempted (already a while ago) to write something for it... but
it's ultra tricky and depends on a lot of stuff (os versions, registry
rights etc etc).

You can download it from my site (address below) and see it it works.
its called MultiTrayPrint


Be sure to start with an empty clean excel before firing it up.
cause if it doesnt work it tends to crash excel...

But if it DOES work it all you need!



keepITcool

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


"Luc Dansereau" wrote:

Hello,

Can anyone tell me if it is possible, using VBA, to control on which
tray the printer must select the paper (when the printer has two or
more paper trays)????

Thanks a lot

Luc

PS

I'd be interested to know if it works.. or how you think it could be
improved. Could you pls email me the results?

and please mention setup..
Excel Version
OS version
Networked setup?
Printer Type?

stuff like that..


keepITcool

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


keepitcool wrote:

Luc,

You cant in standard excel as you can in Word/Access and most other
apps.


I've seen some approaches using sendkeys but there not really
flexible.

I've attempted (already a while ago) to write something for it... but
it's ultra tricky and depends on a lot of stuff (os versions, registry
rights etc etc).

You can download it from my site (address below) and see it it works.
its called MultiTrayPrint


Be sure to start with an empty clean excel before firing it up.
cause if it doesnt work it tends to crash excel...

But if it DOES work it all you need!



keepITcool

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


"Luc Dansereau" wrote:

Hello,

Can anyone tell me if it is possible, using VBA, to control on which
tray the printer must select the paper (when the printer has two or
more paper trays)????

Thanks a lot

Luc