Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can i size an Excel workbook window's opening size? | Excel Discussion (Misc queries) | |||
custom size (page size) missing in excel 2003 | Setting up and Configuration of Excel | |||
Cell size? Or size limit for Text data type? | Excel Discussion (Misc queries) | |||
My tabs' font size is smaller - how do I restore default size? | Excel Discussion (Misc queries) | |||
Font size prints same size regardless of how I set it in Excel | Excel Discussion (Misc queries) |