Duplicated Post - Sorry!

Hi Guys.
New to this forum.
Been using a script created by Frank Heindorfer for some time now to convert an Excel spreadsheet into a .pdf using PDFCreator. It works very well, but now the company want the .PDF output to be Black & White (The Input Spreadsheets are always brightly coloured). Is there a line of code I can add to the script {perhaps similar to “.cOption(“Black&WhiteOutput”) = True”} etc. to achieve this?
Any assistance gratefully received!


if all PDFs created need to be b/w, you can enable this in the printer settings of the PDFCreator virtual printer (windows contol panel->printers)