What version of excel are you using? .xlsx or .xls
My copy of Excel is 2007. As I say, I can execute single commands to get the desired result.
The script command is Export Records, and I select "Excel Workbooks" (type .xlsx) as my output type. (.xls is not an option).
Okay, I think I found it. FIrst, I've changed to the "Save Records as Excel" command.
Also, you need to do more than just select the File Type in the "Select Output FIle" window. The Output File Path List needs to include the .xlsx suffix. So in the example above, the command should have been:
Export Records [No Dialog; "UpcomingRenewals.xlsx"; Automatically open; Western European]