title: VBA DoCmd.TransferText - exporting query to .csv with user defined file path
body: <p>Currently my code is this:</p>
  
  <pre><code>Dim testSQL As String
  Dim qd As DAO.QueryDef
  
  testSQL = "SELECT * FROM qryExample WHERE exampleID IN (" &amp; strExampleIDList &amp; ")"
  Set qd = db.CreateQueryDef("tmpExport", testSQL)
  DoCmd.TransferText acExportDelim, , "tmpExport", "C:\export.csv"
  db.QueryDefs.Delete "tmpExport"
  </code></pre>
  
  <p>How do I change the "C:\export.csv" part so that the user is able to define the file path and the file name?</p>
  
  <p>Thanks.</p>