Posted to microsoft.public.excel.programming

Craig[_21_] Craig[_21_] is offline

external usenet poster

Posts: 39

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Look up a value from a row after verifying two other values	Paul W	Excel Worksheet Functions	11	September 1st 08 08:59 PM
members on my network printer not able to print to default printer	smeheut	Excel Discussion (Misc queries)	0	June 18th 07 06:42 PM
Printer Multiple Worksheets with a particular Printer Setting	PP[_2_]	Excel Worksheet Functions	0	March 14th 07 02:02 PM
Verifying value of a cell	El Criollo	Excel Discussion (Misc queries)	7	December 12th 06 10:21 AM
Verifying Dates	gilbert	Excel Worksheet Functions	1	September 8th 05 03:22 AM

All times are GMT +1. The time now is 02:10 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us