title: Macro to export Excel Doc as PDF for all Users
body: <p>I need to create a macro that will save an excel document as a PDF file to any user's desktop (i.e. multiple people will be using this document/macro). </p>
  
  <p>Here is VBA code I have so far:</p>
  
  <pre><code>Sub CreatePDF()
  '
  ' CreatePDF Macro
  '
  
  '
      ChDir "C:\Users\Public\Desktop"
      ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
          "C:\Users\Public\Desktop\QuickView Update Dec_2017.pdf", Quality:= _
          xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas:=False, _
          OpenAfterPublish:=True
  End Sub
  </code></pre>
  
  <p>I think the issue is with the directory it's saving to (in the instances where this code says "Public" in the file path, I had changed that from my username which was initially populated).</p>
  
  <p>Does anyone know a way to specify a generic path to save this document as a PDF to any users' desktop?</p>