+ Reply to Thread
Results 1 to 3 of 3

Printer select code help please.

  1. #1
    Forum Contributor
    Join Date
    12-08-2013
    Location
    Perth, Australia
    MS-Off Ver
    Excel 2010
    Posts
    117

    Printer select code help please.

    I have some code that directs print to a specific printer, how do I set it so it opens the printer dialoge window so we can select printer and properties?

    Thanks


    Please Login or Register  to view this content.

  2. #2
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    2013 on Win10 (desktop), 2007 on Win10 (notebook)
    Posts
    8,097

    Re: Printer select code help please.

    Hi, 4lowie,

    maybe try
    Please Login or Register  to view this content.
    Ciao,
    Holger
    Use Code-Tags for showing your code: [code] Your Code here [/code]
    Please mark your question Solved if there has been offered a solution that works fine for you

  3. #3
    Forum Contributor
    Join Date
    12-08-2013
    Location
    Perth, Australia
    MS-Off Ver
    Excel 2010
    Posts
    117

    Re: Printer select code help please.

    I replaced the "Application.ActivePrinter" line with "Application.Dialogs(xlDialogPrint).Show"
    This is sort of what I'm after but can I default it to print the selction not the active sheet? When the printer dialog box opens it defaults to print active sheet, I'd like it to default to active selection...

    Idea's please.

    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] 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
  2. How Do I Code to print to a Printer by the Printer Name?
    By rkjudy in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-13-2013, 05:28 PM
  3. Macro to Select Printer
    By JoeyDvivre in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-23-2010, 02:03 AM
  4. Select Printer Macro
    By mdma in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-20-2008, 04:49 AM
  5. How can I select printer drawer?
    By Bafa in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-18-2008, 08:22 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