title: Dialog Box for Save As location in VBA Macro
body: <p>I'm trying to export a file as a PDF as part of a larger macro.  However, I'd like the user to have the option of saving the file to a directory of his or her choosing, and I think this would be easiest with a browsing dialog box.  However, I can't figure out how to pull one up.  Currently, my code reads as follows.  </p>
  
  <pre><code>ActiveWorkbook.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
      "C:\Users\&lt;filepath&gt;\11.08E PT5 Executive Summary - v3.2.pdf", _
      Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas _
      :=False, From:=1, To:=3, OpenAfterPublish:=True
  </code></pre>
  
  <p>I'd like to replace  with the result of the dialog box.</p>