multiple printer codes

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

kurt - 13 Sep 2005 17:47 GMT

In Word 2003, I've created a macro to select certain trays for paper type,
such as bond, draft, etc. My firm has multiple different printers, and I'd
like to have the macro automatically select a certain tray BASED on the
active printer. Is there an IF statement, for example, that I can use? i.e.
My button for selecting BOND paper would do something like the following: If
active printer=Mickey, tray3, if active printer=Minnie, tray 2, etc. I know
how to set up the VBA for the page setup and trays, I just need the piece for
the conditional statement for the printers.

THANKS so much for your help!

Signature

kurt

Reply to this Message

Doug Robbins - 15 Sep 2005 05:40 GMT

There certainly is an If...then...Else construction in VBA.

To get the name of the current printer, use Application.ActivePrinter

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> In Word 2003, I've created a macro to select certain trays for paper type,
> such as bond, draft, etc. My firm has multiple different printers, and
[quoted text clipped - 11 lines]
>
> THANKS so much for your help!

Reply to this Message