Updating the" printing quality" option of PDFCreator via a VBA macro

Hi all,

I generate A PDF of excel sheets from a VBA macro using a "print out".

Some pages are truncated and this is due to the fact that PDFCreator applies the maximum printing resolution quality by default. 

So, the question is how to change the default value of this option.

When using the on line window of PDFCreator this value is accesed via the advanced button of the configuration window. Its french name is "qualité d'impression". I assume this is a direct translation from English "Printing Quality".

Since I generate the PDF via a VBA macro, I need to make to update this parameter in the macro but I did not find one cOption that easily maps to it.


The trial with  the cOption "PDFGeneralResolution" did not work(see code below). So I guess this is not the right option.


  Set cPDF = CreateObject("PDFCreator.clsPDFCreator")
  With cPDF
   .cOption("AutosaveFormat") = 0                            ' 0 = PDF
    .cOption("PDFGeneralResolution") = 600


Can somebody help me ?

I wish a very happy new year to all of you;

Mister Red

More precisely, the setting I try to update via a VBA macro is located in the advanced settings panel under the graphic section. It is "Qualité d'impression" in French wich is tranlted by "priting quality". The displayed default value is 3600 and I would like to change for a lower value. But I don't find the corresponding clsPdfCreator cOption.

Thanks for any help.

Mister Red

Did this ever get answered?

I've "poked around" for some time out here, and there isn't a clear, definitive solution provided.