Pdf created from excel using a macro is very big

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I use Qlikview macro to export reports to excel and then convert them to PDF files in Macro.

If I convert the excel to PDF in my MSExcel the file size is more or less equal to excel, But if I do that in macro file size is 10 times bigger.

Code used is

ActiveWorkbook.ExportAsFixedFormat xlTypePDF, vFilePath&vFileName, xlQualityMinimum, False

I don't see any difference when I use xlQualityMinimum or xlQualityStandard in macro.

Excel File is 909 KB

Macro converted PDF file is 11,824 KB

MSExcel converted PDF file is 519 KB for standard

MSExcel converted PDF file is 243 KB for Minimum Size

It will much appreciated if any body could help.

Thanks

Widaad

topic Pdf created from excel using a macro is very big in QlikView