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

[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.

 

[Jean-Yves]

Hi Alan,

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

Regards

Jean-Yves

 

[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

 

[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.)

 

[Alan]

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




{Bump}