![]() |
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