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