Detecting a printer is connected

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Try this

Untested but try this

If Application.ActivePrinter = "" Then Exit Sub
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Windows 10 Windows 10 can't find scanner (part of an multi-function printer) 6
Epson XP-3150 not printing 2
Epson Printer Problem 6
Printer purchase help and advice 10
Canon TS5060 Inkjet Printer 2
HELP: how to detect if printers are installed? woes :S 1
Printing Via By Macro for Network Printer 2
Run Macro If Cell have "x" value 0

Back
Top