Report exports to Excel but cannot open

[uoghk]

I use below code to generate a Excel file for client A123 statement.
The Excel file is exported.


But cannot open with message "File format or file extension is not valid"

DoCmd.OpenReport "rptStatement", acViewPreview, , "CustNo='A123'", acHidden
DoCmd.OutputTo acOutputReport, "rptStatement", acFormatXLS, "C:\Temp\A123Statement.xlsx"

Do I need to remove the statement's header and just leave the detail section ?
Thanks

[Welshgasman]

Well I would start by changing the extension to .xls?
What version of Office are you using?

Then again I have Google on this laptop.

https://www.devhut.net/docmd-outputt...l-2007-format/

https://www.devhut.net/access-bug-do...x-doesnt-work/

[ranman256]

use: docmd.Transferspreadsheet,acSpreadsheetTypeExcel12 Xml

it opens w/o complaint.

[uoghk]

thank ranman256.
it works.