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.