| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Parameters of a printer
Hi,
Is it possible to change the parameters of a printer with VBA ? My printer can print on both sides and I would like to change the parameters to print on both sides according to criteria but all automatically. Thank you for your assistance. -- Patrick |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Parameters of a printer
The easiest way would be to define another printer driver that would have the
settings to do what you want. Then you just select that using ActivePrinter. Beyond that you are into the windows API: http://tinyurl.com/4khvy -- Regards, Tom Ogilvy "Patrick" wrote: Hi, Is it possible to change the parameters of a printer with VBA ? My printer can print on both sides and I would like to change the parameters to print on both sides according to criteria but all automatically. Thank you for your assistance. -- Patrick |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Parameters of a printer
Hi,
Thank you for your help. I'll test your idea. Regards. -- Patrick "Tom Ogilvy" wrote: The easiest way would be to define another printer driver that would have the settings to do what you want. Then you just select that using ActivePrinter. Beyond that you are into the windows API: http://tinyurl.com/4khvy -- Regards, Tom Ogilvy "Patrick" wrote: Hi, Is it possible to change the parameters of a printer with VBA ? My printer can print on both sides and I would like to change the parameters to print on both sides according to criteria but all automatically. Thank you for your assistance. -- Patrick |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| members on my network printer not able to print to default printer | Excel Discussion (Misc queries) | |||
| Printer Multiple Worksheets with a particular Printer Setting | Excel Worksheet Functions | |||
| too few parameters | Excel Discussion (Misc queries) | |||
| too few parameters | Excel Programming | |||
| Send printer escape commands to a printer using VBA | Excel Programming | |||
![Patrick[_16_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
