Export a REPORT to Excel 1

[rfoye]

No, I don't want to transfer the underlying data set. I know how to do that. I need to be able to do the equivalent of the "Analyze it with MS Excel" menu selection.

I can select a report, go the the menu and select "Analyze it" and an excel file will be created that retains the column formating and totals that the report has. However, TransferSpreadsheet doesn't work with reports. Is the ANY way to perform the "Analyze it" function using VBA?

-------------------
Rob Foye
Database Management
Regions Bank

 

[Remou]

You can use OutputTo, but the formatting will be a little odd.

 

[rfoye]

Thanks, Remou. I had just found the OutputTo action when your reply came in. It did what I needed it to do.

-------------------
Rob Foye
Database Management
Regions Bank