Excel/VBA does not expose a Printer object (or the Printers collection) that
other apps and vb5/6 have.
However, you may be able to Open a file to printer port if the printer is
local. Not sure if the changes will for Excel and subsequent print jobs as
you are bypassing all drivers.
http://vb-helper.com/wanted.htm#print, point # 16.

Otherwise there all the *Printer API routines, where you should be able to
do pretty much anything.

NickHK

"Windsong1948" ...
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.