Show Printer Properties Window

VBA : Printing: Show Printer Properties Window

Options: Save as PDF | Save attached file | Toggle line numbers

Details:

Type:	sub
Added By:	Rembo
Short Description:	Excel can show a number of standard dialogs with the (Application.)Dialogs property. Unfortunately some of the dialogs we use can't be accessed this way, for example a Printer Properties window. This piece of code gets you there using another route.
Added:	Sep 22 2005 at 2:40 PM
Modified:	Nov 6 2006 at 4:03 PM
Related URLs	http://www.puremis.net/excel/cgi-bin/yabb/YaBB.pl?num=1126578994/7#7 http://www.dx21.com/SCRIPTING/RUNDLL32/VIEWITEM.ASP?OID=145&CMD=P-A

Usage:

The part after \n can be defined in two ways:
1) Use the exact printername as it appears in your printer menu (case sensitive)
   e.g.  /n"HP Laserjet IIIP"
2) The UNC name of a shared printer. E.g. /n\\SERVER\SHAREDPRINTER

Code:

Formatted | Unformatted

Sub ShowPrinterProperties()
    Call Shell("rundll32 printui.dll,PrintUIEntry /p /n yourprinter")
End Sub

User comments :

Add a new comment

Scriptorium

VBA : Printing: Show Printer Properties Window

Details:

Usage:

Code:

User comments :