DoCmd.OutputTo acOutputReport, "yourReportName", _
and failed - the output had some column and some row headers, but no data.
An Alternative, ugly as is sounds, is to output it to .rtf format (subb "RTF" for each "XLS" in the above, then copy & paste into excel.
You'll probably want to redesign your report with extra controls here and there (Visible, but font=white) to force your report columns into their proper places in Excel. Even then, teh formatting will be poor, your pagination will be shot, forumlas will be gone. I checked the forum today looking for solutions to the latter two problems.