Controlling two different printer trays

Luc Dansereau · Jul 12, 2003

Hi,

I'm wondering if it is possible to control the printer tray using VB in
excel. My printer has two different trays using the same size of paper but I
want to put header sheets in the first one and usuel sheets in the second
one.

My program, if possible, needs to print the first page in the tray 1, the
two next pages in the tray 2 and the other pages in the tray 1.

Thanks for your precious help

Luc Dansereau

Tom Ogilvy · Jul 14, 2003

You have to use the Windows API to do it.

Here is a discussion on setting such as this:

http://www.microsoft.com/accessdev/articles/getzch10.htm?&gssnb=1

Regards,
Tom Ogilvy