+ Reply to Thread
Results 1 to 4 of 4

Select printer

  1. #1
    Forum Contributor
    Join Date
    08-20-2013
    Location
    LX
    MS-Off Ver
    Office 2019
    Posts
    164

    Question Select printer

    Hello everybody,

    I have this vba which I made with the marco recorder. It works fine, but how can I add a specific printer name? When running this macro I want that it print on a specific printer and not the default one.

    Thanks for your help

    Please Login or Register  to view this content.

  2. #2
    Forum Expert gmr4evr1's Avatar
    Join Date
    11-24-2014
    Location
    Texas
    MS-Off Ver
    Office 2010 and 2007
    Posts
    3,448

    Re: Select printer

    Try adding this after your sub tittle
    Please Login or Register  to view this content.
    1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
    You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.

    Tom

  3. #3
    Forum Contributor
    Join Date
    08-20-2013
    Location
    LX
    MS-Off Ver
    Office 2019
    Posts
    164

    Re: Select printer

    Hello gmr4evr1.

    I gave it a try, but I always recieve an error message. Message is : Run-time error '1004': Method 'ActivePrinter' of object'_Global'failed.
    I enter you code like that:

    Please Login or Register  to view this content.
    Printer name is correct: Devices and Printers_2016-02-10_08-02-38.jpg

    What am I doing wrong?

  4. #4
    Forum Expert gmr4evr1's Avatar
    Join Date
    11-24-2014
    Location
    Texas
    MS-Off Ver
    Office 2010 and 2007
    Posts
    3,448

    Re: Select printer

    Try this instead...
    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Macro that select the printer
    By robrobet in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-13-2015, 03:43 PM
  2. How do I select printer using VBA?
    By JS in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-12-2014, 07:32 AM
  3. Printer select code help please.
    By 4lowie in forum Excel General
    Replies: 2
    Last Post: 03-24-2014, 04:10 AM
  4. Macro to Select Printer
    By JoeyDvivre in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-23-2010, 02:03 AM
  5. Select Printer Macro
    By mdma in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-20-2008, 04:49 AM
  6. How can I select printer drawer?
    By Bafa in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-18-2008, 08:22 AM
  7. [SOLVED] No printer select in excel
    By jj in forum Excel General
    Replies: 1
    Last Post: 03-25-2005, 08:06 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1