Detecting Printers

Izar Arcturus · Mar 25th, 2002, 02:24 PM

Hello all,

Is there code that allows a macro to detect all the printers available for a user.

I am already aware of the command:

Application.ActivePrinter.

I want to be able to change the active printer to "Generic / Text Only on ..." at the beginning of a macro and then be able to switch it back to the original printer at the end of the macro. This greatly increases the speed of execution for my macro, but "Generic / Text Only on LPT1" is the driver on my computer and "Generic / Text Only on ne00" is the driver on my bosses computer. I need code that will allow the macro to acurately detect the driver for this change to work.

Please let me know your thoughts. Thank you.

Tom Schreiner · Mar 25th, 2002, 03:25 PM

Your getting deep here!

Best bet:

Search Microsoft for:

Win32 Software Development Kit
see > PrtDevMode, PrtDevNames, PrtMip...
Good Luck!

Jack in the UK · Mar 25th, 2002, 03:49 PM

Hi --

To add:

Printing to networks printers DOGGY! i have suffered this one and always rember under armagedon the drive or in this case printer seen as Jack1 and Jack2 the servers see as UK1 and UK2 just for fun, so its frawt with windows for error to pop up..

OK you asked for ideas, this is my way i use everday to maintain contol:

I run script to produce letters and so then save as unique file name and save in MYDIR, i then select all and manually assign to the printer i choose setting the configeration as i want.. Macros dont like manual feeds for top try in dual bins or not that i ever solved. Also ever tried duplex prints on the fly via VBA NASTY!

my way worth a try takes seconds longer and is hitch free. time it right and even time for coffee!

Mar 25th, 2002, 03:49 PM	#3
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	Hi -- To add: Printing to networks printers DOGGY! i have suffered this one and always rember under armagedon the drive or in this case printer seen as Jack1 and Jack2 the servers see as UK1 and UK2 just for fun, so its frawt with windows for error to pop up.. OK you asked for ideas, this is my way i use everday to maintain contol: I run script to produce letters and so then save as unique file name and save in MYDIR, i then select all and manually assign to the printer i choose setting the configeration as i want.. Macros dont like manual feeds for top try in dual bins or not that i ever solved. Also ever tried duplex prints on the fly via VBA NASTY! my way worth a try takes seconds longer and is hitch free. time it right and even time for coffee! __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 25th, 2002, 02:24 PM	#1
Izar Arcturus New Member Join Date: Mar 2002 Posts: 2	Hello all, Is there code that allows a macro to detect all the printers available for a user. I am already aware of the command: Application.ActivePrinter. I want to be able to change the active printer to "Generic / Text Only on ..." at the beginning of a macro and then be able to switch it back to the original printer at the end of the macro. This greatly increases the speed of execution for my macro, but "Generic / Text Only on LPT1" is the driver on my computer and "Generic / Text Only on ne00" is the driver on my bosses computer. I need code that will allow the macro to acurately detect the driver for this change to work. Please let me know your thoughts. Thank you.

Mar 25th, 2002, 03:25 PM	#2
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	Your getting deep here! Best bet: Search Microsoft for: Win32 Software Development Kit see > PrtDevMode, PrtDevNames, PrtMip... Good Luck!