Print a word doc from Excel
 

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

Print a word doc from Excel
 

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