<div>
<div class="content wysiwyg-content">
I have the following line of code in my sub routine:<br />
DoCmd.OutputTo acTable, &quot;Tbl_qry_EOM_Results&quot;, acFormatXLS, &quot;&quot;, True, &quot;&quot;, 0<br />
<br />
It outputs to Microsoft Excel 5.0/95 Workbok format and I would like it output to the most recent Excel.
</div>
</div>


I have the following line of code in my sub routine:
DoCmd.OutputTo acTable, "Tbl_qry_EOM_Results", acFormatXLS, "", True, "", 0

It outputs to Microsoft Excel 5.0/95 Workbok format and I would like it output to the most recent Excel.

OutputTo specify most recent Excel file format

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.