Resetting the Active Printer
 

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

Resetting the Active Printer
 

Subject: Printing To A Specified Printer
From: (DennisE)
Date: 1/6/2004 2:17 PM Eastern Standard Time
Message-id:

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