I am just learning VBA printing options, so bear with my novice-ness. :)

I'm writing a snippet of code to automate a print job. As part of the job,
I would like to three-hole punch certain pages and staple others. These
options (three-hole punching and stapling) are available through the
PRINTER->PROPERTIES menu, but I do not see any language reference to this
area in VBA. Is it possible for me to automate access to "special" printer
functions through VBA? If so, how?

Thanks in advance for any help and/or advice.

Re: Custom printing options available through VBA? by Word

Word
Mon Feb 07 01:01:22 CST 2005

G'day "RacinMyLancer" <RacinMyLancer@discussions.microsoft.com>,

The easiest way of doing this is create separate printer drivers for
each group of settings and then just print to the appropriate printer.
Eg, My HP 1234 - Normal, My HP 1234 - Duplex punched, My HP 1234 -
Duplex unpunched

Steve Hudson - Word Heretic

steve from wordheretic.com (Email replies require payment)
Without prejudice


RacinMyLancer reckoned:

>I am just learning VBA printing options, so bear with my novice-ness. :)
>
>I'm writing a snippet of code to automate a print job. As part of the job,
>I would like to three-hole punch certain pages and staple others. These
>options (three-hole punching and stapling) are available through the
>PRINTER->PROPERTIES menu, but I do not see any language reference to this
>area in VBA. Is it possible for me to automate access to "special" printer
>functions through VBA? If so, how?
>
>Thanks in advance for any help and/or advice.


Re: Custom printing options available through VBA? by RacinMyLancer

RacinMyLancer
Mon Feb 07 16:55:04 CST 2005

A thousand thanks... solved my problem!

"Word Heretic" wrote:

> G'day "RacinMyLancer" <RacinMyLancer@discussions.microsoft.com>,
>
> The easiest way of doing this is create separate printer drivers for
> each group of settings and then just print to the appropriate printer.
> Eg, My HP 1234 - Normal, My HP 1234 - Duplex punched, My HP 1234 -
> Duplex unpunched
>
> Steve Hudson - Word Heretic
>
> steve from wordheretic.com (Email replies require payment)
> Without prejudice
>
>
> RacinMyLancer reckoned:
>
> >I am just learning VBA printing options, so bear with my novice-ness. :)
> >
> >I'm writing a snippet of code to automate a print job. As part of the job,
> >I would like to three-hole punch certain pages and staple others. These
> >options (three-hole punching and stapling) are available through the
> >PRINTER->PROPERTIES menu, but I do not see any language reference to this
> >area in VBA. Is it possible for me to automate access to "special" printer
> >functions through VBA? If so, how?
> >
> >Thanks in advance for any help and/or advice.
>
>