ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Parameters of a printer (https://www.excelbanter.com/excel-programming/384190-parameters-printer.html)

Patrick[_16_]

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

Tom Ogilvy

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


Patrick[_16_]

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



All times are GMT +1. The time now is 10:42 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com