Hi,
I have an Excel macro which opens, edits then prints a number of word docs. My problem is that they print in black and white. I can't mess about with default print settings as this will be used by other people, it needs to print in colour regardless of their defaults.
How do I tell Excel to do this?
I hope someone can help. Seems like such a simple thing.
Edit - I've tried recording a Word macro, where I'll print and change to colour. I get this...
Which seems to give me every possible option other than colour. What's the score here?
I have an Excel macro which opens, edits then prints a number of word docs. My problem is that they print in black and white. I can't mess about with default print settings as this will be used by other people, it needs to print in colour regardless of their defaults.
How do I tell Excel to do this?
Code:
objdoc.PrintOut (In Colour)
I hope someone can help. Seems like such a simple thing.
Edit - I've tried recording a Word macro, where I'll print and change to colour. I get this...
Code:
Application.PrintOut FileName:="", Range:=wdPrintAllDocument, Item:= _ wdPrintDocumentContent, Copies:=1, Pages:="", PageType:=wdPrintAllPages, _
ManualDuplexPrint:=False, Collate:=True, Background:=True, PrintToFile:= _
False, PrintZoomColumn:=0, PrintZoomRow:=0, PrintZoomPaperWidth:=0, _
PrintZoomPaperHeight:=0
Which seems to give me every possible option other than colour. What's the score here?
Last edited: