I'm not sure if "Printer" is a reserved word, but it's probably best
avoided.
Sound like the .Text is not a valid setting.
Is it something like "\\MyNetwork\Copier on Ne04:"

NickHK

"FCC" <FCC.2ag9qn_1152065402.6586@excelforum-nospam.com> wrote in message
news:FCC.2ag9qn_1152065402.6586@excelforum-nospam.com...
>
> Hello,
>
> I have a combo box which automatically fills up with the printers that
> are added to the computer's system. And then when the user presses the
> print button, I have the following code:
>
>
> Code:
> --------------------
>
> Application.ActivePrinter = printer.Text
>
> --------------------
>
>
> Where printer.Value is the value of the combo box which has a list of
> printers.
>
> But I get the
>
> >
> > Run-Time error '1004'
> > Method 'ActivePrinter' of object '_Application' failed
> >
>
> What is the problem here?
>
>
> --
> FCC
> ------------------------------------------------------------------------
> FCC's Profile:
http://www.excelforum.com/member.php...o&userid=35888
> View this thread: http://www.excelforum.com/showthread...hreadid=558282
>