Cognos macros

[spanta]

Hi !

I know that you might think that this is a stupid question, but I have only recently started to use Cognos and came across macros today.

It is probably a very simple code, but can someone help me write a code where I have a macro which opens a cognos .ppr file from a particular location and then saves the report as a excel file (preferbably with the same name as the .ppr file) before exiting.

I have managed as far as opening the .ppr file, but cannot suss out how to save the file as a excel sheet.

Any help will be greatly appreciated

 

[mennooo]

Use the following line:

Report.SaveAs FileName , 4

Regards

Menno

 

[DeWegenwachter]

The help file of the Cognos Script Editor is very usefull. Most of the things you want to do with a macro are described in the help file. Save a PPR file as a XLS file is very easy. So see the help file for more support!

 

[Tuskyny]

Hey Spanta,
If you were able to open the .ppr you can close and save as excell..don't really know what your script looks like....can you paste it here so I can see if I can add the line to save as excell
Goodluck

Thanks,
Tusky
IT/Programmer