Resetting the Active Printer

  • Thread starter Thread starter Sue
  • Start date Start date
S

Sue

How can I get this statement to work without including
the PORT #?? The following will work correctly

Application.activeprinter = "acrobat distiller on Ne03:"

but I just want to use the name - ie.

Application.activeprinter = "acrobat distiller"

and this is not acceptable.

Any thoughts would be greatly appreciated!

Thanks!
Sue
 
Subject: Re: Printing To A Specified Printer
From: (e-mail address removed) (DennisE)
Date: 1/6/2004 2:17 PM Eastern Standard Time
Message-id: <[email protected]>

Sue, as far as I know you must specify
the port along with the printer name in
trying to do what you want. HOWEVER, be aware that there's a bug in Excel that
may cause others on the network much grief if you change the active printer
that way; e.g., Application.ActivePrinter="acrobat distiller on Ne03:"

What happens is that the system default printer across the entire Windows
environment is changed to that printer, just as though you went to the Control
Panel and made that change. Not only that, but it will make this change on an
instantaneous basis, so the other users in the middle of printing on the system
will have their output messed up accordingly. This not-so-well-known bug in
Excel is documented in MS Knowledge Base Article 209722.

-- Dennis Eisen
 
Back
Top