Use VBA to access Printer Properties (Resolution, Tray etc)

A

Alan

Hi All,

Is there any way to use VBA to access the printer properties dialogue
box?

I am talking about the options that are specific to the selected
printer, such as which tray to print to, what resolution to print at
etc.

I know I could use SendKeys, but that seems a little clunky and
potentially uncertain.

Is there another way that I am missing?

Thanks,

Alan.
 
J

Jean-Yves

Hi Alan,

Hes it is possible but very complicated. You can use API function to access
such properies but ....

Regards

Jean-Yves
 
R

Rob van Gelder

To change options within the Print window - not sure how to do it with code.
Probably SendKeys is the only option.

To open the Print window:
Application.Dialogs(xlDialogPrint).Show
 
D

Dave Peterson

How about setting up another printer the way you want it (outside excel).

Then just change printers within your code.

(Not so nice if you have a bunch of people running the macro.)
 
Top