Export Impromtpu Results to Excel

[ADB1]

Has anybody tried to export reults automatically from more than one scheduled impromptu report to excel, via a macro for example? We want the results from the different impromptu reports all to be exported to the same excel workbook.

Thanks in advance,

Adam

 

[jbecher]

I would use a standard convention for naming the exported Excel sheets (e.g. report01.xls, report02.xls, etc).

Then write a little macro routine that would take the base name (report) and loop through all of the exported reports, adding them to an Excel workbook with Excel automation.

HTH,

Justin

 

[ADB1]

Is this quite simple to do? I'm afraid I am not that familiar with Cognos macros!