<div>
That was the quickest solution I ever got to one of my questions. Thanks.
</div>


That was the quickest solution I ever got to one of my questions. Thanks.

<div>
Did you catch what the problem was?<br />
DoCmd.TransferSpreadsheet acExport, <b>acSpreadsheetTypeExcel9</b>, &quot;qryalltimerecordsbydate&quot;,<wbr /> myfilename<br />
This is the filetype for a .xls export, and you specified a .xlsx filename<br />
Hence the problem<br />
acSpreadsheetTypeExcel9 has a value of <b>8<br />
</b><br />
Rey had you substitute in <b>10 </b> to match the .xlsx filetype.
</div>


Did you catch what the problem was?
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "qryalltimerecordsbydate", myfilename
This is the filetype for a .xls export, and you specified a .xlsx filename
Hence the problem
acSpreadsheetTypeExcel9 has a value of 8

Rey had you substitute in 10 to match the .xlsx filetype.

<div>
<div class="content wysiwyg-content">
I am using the following code to export a query from Microsoft Access 2013<br />
myfilename = &quot;W:\AD_Reports\AnotherTest<wbr />.xlsx&quot;<br />
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, &quot;qryalltimerecordsbydate&quot;,<wbr /> myfilename<br />
Everything seems to work but when i try to open the file it gives a message Format or File Extension not valid. I deleted the file and did it over and it still produces the same error. &nbsp;Thanks for any help.
</div>
</div>


I am using the following code to export a query from Microsoft Access 2013
myfilename = "W:\AD_Reports\AnotherTest.xlsx"
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "qryalltimerecordsbydate", myfilename
Everything seems to work but when i try to open the file it gives a message Format or File Extension not valid. I deleted the file and did it over and it still produces the same error.  Thanks for any help.

Microsoft Access 2013  TransferSpreadsheet generates Excel but When it is opened Extension Not Valid Error

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.

Microsoft Access

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

Microsoft Office

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.