Default Printer

[carlito_1985]

Hi, is there any way to make excel, when it opens to make a printer the default printer, and when you close it, revert back to initial printer?
Thanks

[NickHK]

carlito_1985,
OldPrinter=Application.ActivePrinter

Application.ActivePrinter=NewPrinter
.................
Application.ActivePrinter=OldPrinter

NickHK

"carlito_1985" <[email protected]>
wrote in message
news:[email protected]...
>
> Hi, is there any way to make excel, when it opens to make a printer the
> default printer, and when you close it, revert back to initial
> printer?
> Thanks
>
>
> --
> carlito_1985
> ------------------------------------------------------------------------
> carlito_1985's Profile:
http://www.excelforum.com/member.php...o&userid=21390
> View this thread: http://www.excelforum.com/showthread...hreadid=382393
>