View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jean-Yves[_2_] Jean-Yves[_2_] is offline
external usenet poster
 
Posts: 253
Default Use VBA to access Printer Properties (Resolution, Tray etc)

Hi Alan,

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

Regards

Jean-Yves

"Alan" wrote in message
...

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.