ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel PDF add-in and PDF size (https://www.excelbanter.com/excel-discussion-misc-queries/146712-excel-pdf-add-pdf-size.html)

RobN[_2_]

Excel PDF add-in and PDF size
 
When I use the Excel add-in to save to PDF in Vs2007 the PDF file size is
130kb, but if I use the Adobe Acrobat Standard printer to create the PDF it
is only 85kb. Furthermore, when using the inbuilt PDF creator in Paradox,
the file size is only 14kb.

Does anyone have any PDF experience to help me reduce the size of PDFs in
Excel? I'd like to get it close to the 14kb size. I have already chosen the
Quality:=xlQualityMinimum

This is the code I use.....
Set rng = SH.Range("F50")
dir = "C:\Documents and Settings\User\My Documents\"
newFileName = rng.Text
Sheets("NSW").Select
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
dir & rng.Text _
, Quality:=xlQualityMinimum, IncludeDocProperties:=True,
IgnorePrintAreas _
:=False, OpenAfterPublish:=False

Rob




All times are GMT +1. The time now is 11:47 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com