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.

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.

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.

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


...


{Bump}