VBA for Printer Settings

[Yuriy B]

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 use record macro option in the File Print Menu; How would I specify in printer Setting Job Type: Normal Print

I have this:

<code style="margin: 0px; padding: 0px; font-style: inherit; font-weight: inherit; line-height: 12px;">Option Explicit
Sub SelectPrinter()
    Dim sNewPrinter As String

    sNewPrinter = ActivePrinter
    ActivePrinter = "XXXXXWestOffice on XXX-XX-001.office.XXXXXmfg.com"


VBA Code
then


    Application.PrintOut Filename:=""                                .Parent.Parent.PrintOut From:=1, To:=3, Copies:=1
    Options.PrintDraft = False                                  

    Sub MacroPint3()
[</code>/CODE]

 

[RobertSF]

A lot of what affects printing is in the PageSetup object. Does this help?
https://msdn.microsoft.com/en-us/vba/excel-vba/articles/pagesetup-object-excel

 

[Yuriy B]

That is an excellent resource, however, it does not talk about if it is possible to record macros or setting Job Type to Normal Print.