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

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.

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.

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

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


--
Rob van Gelder - http://www.vangelder.co.nz/excel


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

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

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 wrote:

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.

--

Dave Peterson

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

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


...


{Bump}