report output format .xlwa when scheduled

Hi Guys

I am using cognos 10 and i have set a folder on cognos server where i want to save report output for report that are scheduled/burst .What i notice is when i try to schedule excel 2007 report.They gets saved in this location as .xlwa now this is suprising and even html reports get saved as .mht

Below is the IBM setting to get rid of this issue .I always paste it here as you can be never sure of ibm link they tend to change over time and gives a broken link

Problem(Abstract)

When using the CM.OUTPUTLOCATION directive, Excel files are exported as .MHT files (the RSVP.FILE.EXTENSION.XLS directive doesn't apply here), and a method was requested to automatically rename the files to .XLS

Environment
The attached batch file is suitable for Windows 2000 / XP / 2003 environments.

Resolving the problem

Using the following in a CM.OutputScript will automatically rename each .MHT file to .XLS as it is produced.

@echo off
cd x:\{report location}
ren x:\{report location}\*.mht *.xls

Steps:
Create a batch file containing the above code.
Add the CM.OutputScript directive, pointing to the path containing the script, into the Advanced Settings for the Content Manager service.


Detailed instructions for setting the CM.OutputScript parameter are contained in the Administration and Security Guide (ug_cra.pdf) shipped with the product, in the chapter entitled "Server Administration"

You can check my earlier post about bursting reports .There its explained how to set this parameter .

http://cognossimplified.blogspot.com/2011/10/where-report-output-from-bursting-are.html