I was able to resolve the issue by using ImportExportToSpreadsheet and exporting to the ExcelBinary format.
yours sincerely
Craig Hoy
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
I've been trying to export an Access Report created in Access for Microsoft 365 to Excel but if I try to export to either XLSX or XLSM formats it creates corrupt files. I've tried using ExportWithFormatting macros, DoCmd.OutputTo & DoCmd.TransferSpreadsheet VBA Code but all 3 alternatives fail. They all work if I use XLS (Excel 2003 or earlier) format. In addition ExportWithFormatting doesn't give me an option for XLSX or XSLM formats. What am I doing wrong?
Yours sincerely
Craig Hoy
I was able to resolve the issue by using ImportExportToSpreadsheet and exporting to the ExcelBinary format.
yours sincerely
Craig Hoy