You can only customer name a sheet in an Excel file using Toad 9.7.2.5 and above.
When you select to export to an Excel format file, there is an option close to the bottom called "Sheet Name" with the entry "<default>". Type in there the name you want for the sheet where your data will go into.
