Excel - VBA - ExportAsFixedFormat PDF File Size too Large
<p>Using a macro to save a copy of a worksheet as a PDF to my desktop.  However, the actual file size when using my macro results in a file size two or three times larger then if I were to manually, in Excel, go to the Acrobat tab and create PDF.  I need to reduce the file size of the pdf further.  I've set a small print area, tried using minimumquality, reducing image sizes before hand, etc.  Is there a better alternative to print a PDF of a worksheet with a smaller file size?  The difference between files is 100kb compared to 280kb.  </p>

<pre><code>ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Quality:=xlQualityMinimum, IgnorePrintAreas:=False, Filename:="C:\
</code></pre>