Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Detecting Printers

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Your getting deep here!

    Best bet:

    Search Microsoft for:

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

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,184
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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"

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •