View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Craig[_21_] Craig[_21_] is offline
external usenet poster
 
Posts: 39
Default Verifying Printer with Excel VBA

Hi...
I know that I can change the printer with:
Application.Activeprinter="HPPhpoto on LPT1:"

Is there any way of checking the existance of the printer before using the
Activeprinter change?
I just want to be sure the printer exist before I create an error if it
doesn't... because I'm dealing with over 100 printers!
Craig