Look at Excel VBA help for application.ActivePrinter

You can get the string the colour printer by selecting it manually, then in
the immediate window you can do

? Application.ActivePrinter

--
Regards,
Tom Ogilvy


"Peter" wrote:

Calling the finest minds of this group:

I have a macro that is editing a word doc, that part is fine. The
problem is how to change the printer settings to use the colour
printer!

Does anyone have any ideas?

Thanks,

Peter