Detecting a printer is connected
 

Hi there,

I have a macro that prints a form but errors if no printer is attached. What
would the vba code be for detecting a printer and ending the sub if one is
not conected

many thanks.

kevin.

Detecting a printer is connected
 

Try this

Untested but try this

If Application.ActivePrinter = "" Then Exit Sub


--
Regards Ron de Bruin
http://www.rondebruin.nl



"kevin" wrote in message ...
Hi there,

I have a macro that prints a form but errors if no printer is attached. What
would the vba code be for detecting a printer and ending the sub if one is
not conected

many thanks.

kevin.