| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
PDF the Excel Report
I have an excel report that I wanted to PDF through the VBA code. But the file size is around 230KB if I PDF the report through the VBA code. If I manually PDF the document, file size is like 120 KB. Pls help me what do I need to fix in the below VBA code to PDF the report to smallest file size.
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _ "C:\Documents and Settings\archith\Desktop\Club Profile\" & ClubNumber & ".pdf", Quality:= _ xlQualityMinimum, IncludeDocProperties:=True, IgnorePrintAreas:=False, _ OpenAfterPublish:=False |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Getting missing data from one report into another report... | Excel Discussion (Misc queries) | |||
| Automate Excel report to place certain data into existing report? | Excel Worksheet Functions | |||
| Header in Report Manager Report | Excel Discussion (Misc queries) | |||
| Fill an individual report with values from a team report? | Excel Programming | |||
| how do i report a bug in excel | Excel Discussion (Misc queries) | |||
Threaded Mode
