I have a problem setting up my printer macro. Excel sets up a printing
session that won't allow my macro to work. So is there a way to bypass
or override the printing session (Ne01) that it sets up? This
macro is supposed to choose a printer, then after printing the
document, it should change it back to the default printer. Please tell
me how to write the proper code.

*Sub Macro3()
'
' Macro3 Macro
' Macro recorded 8/12/2005 by Tygi

'
Application.ActivePrinter = "\\ATLAS\DoorshopRicoh1013F on Ne01:"
ActiveWindow.SelectedSheets.PrintOut Copies:=1, ActivePrinter:= _
"\\ATLAS\DoorshopRicoh1013F on Ne01:", Collate:=True
Application.ActivePrinter = "\\ATLAS\Ricoh1013FPCL6 on Ne01:"
End Sub*


--
tygi
------------------------------------------------------------------------
tygi's Profile: http://www.excelforum.com/member.php...o&userid=26769
View this thread: http://www.excelforum.com/showthread...hreadid=400260