select between different paper trays for printing. 1

[benzagod]

My excel 2000 VBA program produces several worksheets in a single workbook. I want to be able select from 2 different “paper trays” on laser printer, for printing the individual worksheets. The printer is PCL6 compatible. Any help or suggestions welcomed on tray selection from within vba.

 

[SkipVought]

Hi,

Set up 2 different printer profiles in Add New Printers in your Windows Printers & Faxes.

Then macro record, selecting a profile in the Print menu.

Skip,

_{[red]Be advised:[/red] The dyslexic, agnostic, insomniac, lays awake all night wondering...
"Is there really a DOG?"}