After exporting a query to an existent [Compatibility mode] Excel file, using DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9,...and opening the Excel file with
.Workbooks.Open(...., , true) I'm getting a [read-only] [Compatibility mode] Excel file. Is there a way to get a only [Compatibility mode] file?
Thanks