title: Size of created pdf file
body: <p>When creating a .pdf file using the code pasted below the size of the file gets to around 375 KB, but when creating a pdf using the built in pdf creator from the print menu in excel, the file only gets about 40 KB</p>
  
  <pre><code>Worksheets("Journal").Activate
  Range("JournalArea").Select
  
  With ActiveSheet.PageSetup
  '.PaperSize = xlPaperA4
  .Zoom = 50
  .BlackAndWhite = True
  End With
  
  With Selection
      .ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
      filePath &amp; title &amp; ".pdf", Quality:=xlQualityStandard, IncludeDocProperties:= _
      True, IgnorePrintAreas:=False, OpenAfterPublish:=False
  End With
  </code></pre>
  
  <p>So the question is, am I including unnecessary data in the pdf file, and if so how do i exclude that?</p>
  
  <p>Any suggestions will be much appriciated.</p>