You really don't want to export a report to Excel (if you think you do try running your report and then click Tools -> Office Links -> Analyse it with Excel). Unless your report is very simple indeed the export should look pretty unintelligible.
You also can't create buttons on reports either
However - if you just want to export a query result to excel check this out:
DBForums Code Bank
HTH