title: Exporting an MS Excel 2003 workbook to PDF via VBA
body: <p>I have an Excel 2003 workbook that contains a macro to copy certain of its sheets across to a new workbook, then save and close the new workbook.  It does this several dozen times, with slightly different sheet selections each time.</p>
  
  <p>I would like to add an extra step to the macro to export the secondary workbooks' spreadsheets to PDF.  The obvious way to do this would be to use a PDF printer and Excel's built in Print function, but most PDF printers give you a "Save As..." dialogue box before they finish.  Obviously, typing this in individually for seventy-odd occasions lacks appeal - so I'd like something that allows me to set it ahead of time (probably "Use the filename of the file I'm printing minus its extension") then just select the default options.</p>
  
  <p>Any ideas for a free PDF printer that does this?  Or a suitable alternative?</p>