Output to Excel application

[Dale]

I am learning how to output a report to a file in Excel format. Is there a
way to output a report to the application (Excel)? i.e. open Excel and the
output would be the rows and columns of the opened workbook. Any help would
be appreciated.

 

[Steve Schapel]

Dale,

Without seeing your project, I may be off-track here, but I have never
seen a situation where exporting a Report to Excel would be worth
considering. Probably you are better to try and export the data from a
Query. The OutputTo macro action has an Auto Start argument, which can
open Excel with the exported data displayed. However, the
TransferSpreadsheet action is probably preferable, in which case you can
follow it with a RunApp action to open the file in Excel.

 

[Dale]

Thanks - I will work with your suggestion.