Test printer parameter before continuing with macro

[Chris Salcedo]

I have a macro that one of the things it does is set the page size to
11x17.

This works great on HP printers (that support that size of course) but
there are some users that use a konica printer that uses tabloid
instead of 11x17. (same size, its just the printer driver recognizes
one and not the other)


to set one up would be

..PaperSize = xlPaper11x17

and for the other one it would be

..PaperSize = xlPaperTabloid

Now my question,

Is there a way that I can test first if the printer driver supports
Tabloid or 11x17??

something like

if ActiveSheet.PageSetup.PaperSize = xlPaper11x17 returns error then
ActiveSheet.PageSetup.PaperSize = xlPaperTabloid



Thanks

Chris

[Tom Ogilvy]

mayber something here you can use:

http://support.microsoft.com/kb/244639/en-us
OFF2000: Macro to Obtain a List of Paper Names Supported by the Active
Printer

--
Regards,
Tom Ogilvy


"Chris Salcedo" <csalcedo@gmail.com> wrote in message
news:1154235078.779968.238280@b28g2000cwb.googlegroups.com...
>I have a macro that one of the things it does is set the page size to
> 11x17.
>
> This works great on HP printers (that support that size of course) but
> there are some users that use a konica printer that uses tabloid
> instead of 11x17. (same size, its just the printer driver recognizes
> one and not the other)
>
>
> to set one up would be
>
> .PaperSize = xlPaper11x17
>
> and for the other one it would be
>
> .PaperSize = xlPaperTabloid
>
> Now my question,
>
> Is there a way that I can test first if the printer driver supports
> Tabloid or 11x17??
>
> something like
>
> if ActiveSheet.PageSetup.PaperSize = xlPaper11x17 returns error then
> ActiveSheet.PageSetup.PaperSize = xlPaperTabloid
>
>
>
> Thanks
>
> Chris
>

[engineerchange]

I found an easy solution for this.

Please Login or Register  to view this content.