To export an Orders report to Excel, I use:
DoCmd.OutputTo acOutputReport, "report_ORDERS", acFormatXLS, "C:\ORDERS.xls".
When I open the Excel file I get the error message: "REPAIRS TO ORDERS.XLS"
In the error log, it logged "Renamed invalid sheet name"
What should the sheet name be, or is there an extra formatting routine required?