Read-only Excel file after using TransferSpreadsheet Method

[SCFM]

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

[SCFM]

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

Ok. I already solved this. To open the Excel file as only [Compatibility mode] just use False instead of True in .Workbooks.Open().

[RuralGuy]

Thanks for sharing your solution.