Size of PDF file with Excel VBA bigger than done manually

[jpbauer]

Hi

I try to automate the PDF generation from an Excel tab with VBA. It's work perfectly except the fact that the size is 4 time bigger (600k versus 150k) than when I do the same manually. That's the code I use:

Worksheets("Facture").PrintOut Copies:=1, ActivePrinter:="Bullzip PDF Printer", printtofile:=True, PrToFileName:="\Downloads\test.pdf ", Collate:=True, IgnorePrintAreas:=False

I think the problem could be from the parameter screen used in the manual way, that could "compressed" the file more than in the "automatic/default" way, even if the parameters are "default" for quality and zoom, PDF 1.5 for compatibily and compressed for image

Do you have an idea ? Is there a way to specify more parameters ?

Regards