title: Output MS Access Query to Excel with vba
body: <p>Working with MS Access 2007, I have a query I'd like to run and export the results to a specific workbook in a saved Excel workbook.  I have the following code written using DoCmd. First I open the query (this works) and then I try to output the results to excel.  </p>
  
  <pre><code>DoCmd.OpenQuery "MyQueryName", acViewNormal, acEdit
  
  DoCmd.OutputTo acOutputQuery, "Aging By Desk - Onboarding Team", acFormatXLS, _
      "filepath.SuperTest.xls", "SuperTest.xls", True
  </code></pre>
  
  <p>However, when this code is run, I get the following error message: "An Expression you entered is the wrong data type for one of the arguments".  I've been playing around with each argument, but can't seem to locate the problem. Any ideas? Am I on the right path?</p>