Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2016-10-04 04:52 AM

Pdf created from excel using a macro is very big

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

668 Views
0 Likes
0 Replies