Is it possible to change printer settings e.g. colour/double-sided in VBA code when automating word documents

[mageeg]

I have written code which at a click of a button, prints off a word document.

I have many different documents to print, all of which have their own button.

The problem is, different documents require different printer settings. e.g. some need colour, some do not.

So it is not possible to set the printer properties, then have them all print out in the same way. Is it possible to set these settings within the code itself?

My code is simple as follows:

Dim wd As Object
Dim wdDOC As Object 'word document

Set wd = CreateObject("Word.Application")

Set wdDOC = wd.Documents.Add("T:\mageeg\RM Manual Rev2.docx")

wd.Visible = False

wdDOC.PrintOut

Set wd = Nothing 'Release memory allocated to WD

MsgBox ("RM Manual Printed")

wdDOC.Close

Set wdDOC = Nothing


End Sub

 

[shknbk2]

The answer here and the link to the MSDN page should be informative.

Printing a Word document in colour using VBA code to print

I have a Word document that we do not want the users to edit once it had been generated from the database. We have set up a VBA module to print the document automatically after opening, but we need...

superuser.com

Hopefully, the printer settings are determined by the document settings to get this to work.