Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to program print preferences
At work a network printer is the default destination, which I have set up to
default to print 2-sided to a Store destination, mailbox 3 on the printer. Documents I create print just fine, but I get many from others at work that I have to manually change to print that way. I want to do this with just a click of a button on my Excel menu bar (once I have the macro, that is no problem). I can't figure out how to do via a macro what I do manually through Print Preferences set the destination to Store and choose Mailbox 3 if that is not already chosen, select 2-sided printing, if not already, then return to the Print box where I will manually choose the number of copies and hit OK to print. I can't find or figure out if there are Excel VBA commands for this, and Sendkeys only gets me part way there. At 20 or more times a day doing this manually, any programming help would be greatly appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sender's print preferences retained on .xls and .doc email attachments | Excel Discussion (Misc queries) | |||
setting print preferences on multiple tabs | Excel Discussion (Misc queries) | |||
Macro for Print Program | Excel Discussion (Misc queries) | |||
program to print some landscape, some portrait? | Excel Programming | |||
Program Print Settings | Excel Programming |