Greetings all

I have a number of programatically created reports that are tastefully
coloured (I hope!)

I am very happy for them to print on colour if the users default
printer is colour.

However if they have a BW printer I would like the report to print in
BW

How can I test for whether the default printer is colour or BW from
within Excel.

I'm guessing it will require an API call

Your thoughts would be appreciated

Cheers

Kieran H