title: Save multiple sheets to .pdf
body: <p>I have a reporting spreadsheet that grabs some data from a database and forms three sheets of summary report information. I want to run the spreadsheet automatically from the command line, and have it automatically save all three reporting sheets as a PDF file(s).</p>
  
  <p>At first I thought I could have a VBA macro on the sheet do this by a series of "print as PDF", but that requires an intermediary interactive dialog box to specify the output file name. Then I find that I can just save as pdf, and the macro can set the output file name.
  However this creates three separate files, and I have to then later put them together externally to merge them.</p>
  
  <p>(It is odd that save as pdf only saves one sheet, where other save modes seem to save the entire workbook.)</p>
  
  <p>Yes, there are tools for merging the three files later, but I want to know if there is some easy way to get Excel to save multiple sheets together as one pdf file.</p>
  
  <p>I print now by a series of things like: </p>
  
  <pre><code>ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, ...
  </code></pre>
  
  <p>Could I do instead a single statement something like (pseudo-code):</p>
  
  <pre><code>ThisWorkbook.Sheets(1,2,3,4).ExportAsFixedFormat Type:=xlTypePDF, ...
  </code></pre>