Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Programming / September 2005

Tip: Looking for answers? Try searching our database.

multiple printer codes

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
kurt - 13 Sep 2005 22:29 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

Jezebel - 14 Sep 2005 10:10 GMT
If [condition] then
   ...
elseif [condition] then
   ....
end if

or

Select case [active printer]
case [printer 1]
   ...
case [printer 2]
   ...
case else
   ...
end select

> 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
[quoted text clipped - 10 lines]
>
> THANKS so much for your help!
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.