printer options

[David C.]

Hello,

I usually print excel and word documents inside my vba code,
but I would like to do a little more than just selecting a printer name...
I mean: it will be great to choose also all the printer parameters and
options
(when you print yourself, without vba, it's the second customisation window)

do you know how to change these options ?

 

[Jay Freedman]

Hi David

Read this series of articles:

Controlling the Printer from Word VBA
by Jonathan West

Part 1: Using VBA to Select the Paper Tray
http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=101

Part 2: Using VBA to control Duplex, Color Mode and Print Quality
http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=116

Part 3: Dealing with Different Paper Sizes
http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=132

Part 4: Getting printer driver details
http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=183

 

[David C.]

I will read the 4 of them
But first I'd really like to thank you for that...


David