Can anyone give me an example of saving a .ppx file as a .csv or .xls in macro script. I am trying to automate this.
This topic has been locked.
1 reply Latest Post - 2010-02-05T03:45:24Z by yangling
Pinned topic Saving Powerplay report as XLS file in macro script
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2010-02-05T03:45:24Z at 2010-02-05T03:45:24Z by yangling
yangling 0600018QDQ38 PostsACCEPTED ANSWER
Re: Saving Powerplay report as XLS file in macro script2010-02-05T03:45:24Z in response to atomictortoiseDid you check online for PowerPlay Macro Reference at
Dim objPPRep as Object
Dim objPPRes as Object
Set objPPRep = GetObject(, "CognosPowerPlay.Report")
Set objPPRes = objPPRep.Columns.CumPercentOfBase _
Set objPPRep = Nothing