I haven't found a way to do this. We tried adding the &dataformat=excel to the end of the url in the report scheduler, but that didn't work. So, the only supported formats are HTML and PDF.
Hope this helps,
Thanks for the response. I think they absiltuely need to allow us to run reports and export them in excel. If I can do it from report writer, I should be able to create a task/job. Now I am saddled with having to run the report manually and exporting it myself. Kind of annoying, but a limitation is a limitation I suppose.