Calling a specific printer?

[Patrick Zirngast]

Hi all!

My Question might seem simple on a first glance, but it isn't. (at least for
me

I made an input menu where the user can specify the pages to be printed and
some other parameters. THis is then sent to a specific printer (e.g.
"CutePDF Writer on CPW2:") which I specified in VBA as activeprinter.

The problem now ist, that we use this Excel sheet on several different Pcs
in our office - the printer is still the same but the "on CPWx:" part
changes from on to another pc.
I tried to leave it away, which gives me a nice error message.

Is there any way to get a list of all printer registered on the system and
then to select the one starting with "Cute*"?

thanks for your help

patrick

[Bob Phillips]

Why not just call up the printer dialog and let them select. Make it part of
the procedures to select the one starting with "Cute".

application.dialogs(xldialogprint).Show

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Patrick Zirngast" <[email protected]> wrote in message
news:[email protected]...
> Hi all!
>
> My Question might seem simple on a first glance, but it isn't. (at least
for
> me
>
> I made an input menu where the user can specify the pages to be printed
and
> some other parameters. THis is then sent to a specific printer (e.g.
> "CutePDF Writer on CPW2:") which I specified in VBA as activeprinter.
>
> The problem now ist, that we use this Excel sheet on several different Pcs
> in our office - the printer is still the same but the "on CPWx:" part
> changes from on to another pc.
> I tried to leave it away, which gives me a nice error message.
>
> Is there any way to get a list of all printer registered on the system and
> then to select the one starting with "Cute*"?
>
> thanks for your help
>
> patrick
>
>