Add three copies of your current printer, each with a different feeder
drawer set....HpLaserJet_dw2 and so on.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
"Windsong1948"
wrote in message
I am in a situation that I need to send an active sheet in Excel directly to
the current printer bypassing the already set printer settings. My printer
has 4 drawers w/different paper in each drawer. When I write a macro it does
not change the drawer to the one I want to use and the settings I have in my
books change from what I have them set at. I wish to make a macro for each
drawer and use HP Printer control codes that will send my print to the proper
drawer. Can this be done? I'm hoping you can help.