I need to import Crystal Reports into Excel.

The typical response to this type of query is "don't worry about importing, just open the report in Crystal and export it to Excel." While that technically works, I want to eliminate the extra steps.

I've got some reports that are for executives and, frankly, asking them to open Crystal, export the data, copy/paste into the Excel, format/manipulate the data from there, and so on, is too much to ask.

My ideal solution is to simply have them open the Excel report, click a button to run a macro, viola! have the report updated.

Is there any way to do this? If so, what's the preferred method? I've toyed with connecting to MS Query, the database itself, going through Access..., all with no luck. I can pull in tables, but not finished reports.