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" wrote in message
...

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