title: MS Access table export as excel file to user defined folder
body: <p>Below code is working fine and exporting access table data into excel file (C:\temp\test.xlsx). </p>
  
  <p>But my requirement is instead of defining C:\temp folder in VBA script, system should ask user to select the output directory. Could you please help me to prepare that VBA script?</p>
  
  <pre><code>Private Sub Command3_Click()
  
   DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12Xml, "Fields", _
         "C:\temp\text.xlsx", True
  End Sub
  </code></pre>