In Excel it is
Application.ActivePrinter

I can't say for word.

--
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