Size of PDF file with Excel VBA bigger than done manually
Posted: Fri Apr 21, 2023 3:55 pm
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
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