ExcelBanter - Default Printer

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Default Printer (https://www.excelbanter.com/excel-programming/332889-default-printer.html)

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

carlito_1985,
OldPrinter=Application.ActivePrinter

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

NickHK

"carlito_1985"
wrote in message
news:carlito_1985.1r9wqe_1119855909.2991@excelforu m-nospam.com...

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