Results 1 to 5 of 5

Set Printer name and Setting in Macro

Threaded View

  1. #1
    Forum Contributor
    Join Date
    08-10-2016
    Location
    Minneapolis, Minnesota
    MS-Off Ver
    Office 365
    Posts
    124

    Set Printer name and Setting in Macro

    Hi,

    I have a Macro that executes commands and prints right after.
    Before I execute the macro, I need to go and change printer and printer settings.
    Is there a way to include printer name and settings in the beginning of the macro before everything gets executed?

    Printer Name: WestOffice on network1
    Printer Properties:
    Job Type
    Normal Print
    Color / Black and White
    Color


    Thanks,
    Yuriy
    Last edited by YuriyBaron; 10-16-2017 at 03:12 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Setting a default Printer for a macro then resetting it back to its original value
    By ashvinsolanki in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-03-2014, 12:08 PM
  2. Setting the default printer
    By martinpgibson in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-19-2013, 05:43 PM
  3. Printing Macro Problem - Setting Default printer
    By jordan2322 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-18-2012, 03:37 AM
  4. macro to print 2 copies to default printer, then 1 copy to Adobe PDF printer
    By jwright650 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-26-2011, 01:07 PM
  5. setting PDF Creator as a default printer thro VBA macro
    By mvel_sky in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-01-2010, 01:43 AM
  6. [SOLVED] Setting EDoc Printer Pro in macro
    By Frank in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-05-2006, 10:55 AM
  7. Setting printer in VB
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-21-2005, 06:05 PM

Tags for this Thread

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