+ Reply to Thread
Results 1 to 3 of 3

tweeking macro to print to specific printer (non default)

  1. #1
    Forum Contributor
    Join Date
    10-18-2010
    Location
    Walla Walla, Washington
    MS-Off Ver
    Excel 2007
    Posts
    124

    Cool tweeking macro to print to specific printer (non default)

    I have a macro I found on this site that I really like. It helps me easily pick select different sheets in the workbook (using check boxs) and sends them to a printer when executed. The only quam I have with the macro is it would be great if one were able to send them to a pre determined printer (other than my normal default printer). I have a PDF creator that is assigned as a printer so it would be nice to have the selected sheets print to that printer versus my default. My goal is to minimize steps in printing. Are there options built into excel that will allow me to do this or will I have to create a new macro or add to the existing one. The marco I have in question is the following, thanks for any and all help;

    ----------------------------------------------------------------------------------------------------------------------

    Please Login or Register  to view this content.
    Last edited by Leith Ross; 10-19-2010 at 11:13 PM. Reason: Added Code Tags

  2. #2
    Forum Contributor
    Join Date
    07-07-2005
    Location
    England
    MS-Off Ver
    Office 2019 Enterprise
    Posts
    473

    Re: tweeking macro to print to specific printer (non default)

    Please Login or Register  to view this content.
    CPW2 is the port the printer is on
    Last edited by johncassell; 10-20-2010 at 11:05 AM. Reason: more detail

  3. #3
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: tweeking macro to print to specific printer (non default)

    This code stores the active printer, changes to CutePDF then restores the printer setting

    Please Login or Register  to view this content.
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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