Set report to excel worksheet using VBA

[former_member591760]

I am trying to programmatically change the worksheet type from “EPM Worksheet” to “Excel Worksheet” using VBA. When I record the steps through the macro recorder it always gives me the two lines of code listed below. The strings would appear to be unique but I get the same code each time I try recording the steps through the macro recorder. And when I try to run the code as a macro in a test file it does nothing to change the worksheet type and does not display any errors.

ActiveWorkbook.Names.Add Name:="EPMWorkbookOptions_1", RefersToR1C1:= _

"=""dgEAAB+LCAAAAAAABACFkMEKgkAQhu9B77DsPVcLOoTaoS5BYhRU10lHXdJZ2d3aHj8pLKpD12++f4b5w/mtqdkVtZGKIh54PmdImcollRG/2GIUTPk8Hg7Cg9Lnk1LntLWdaliXIzO7GRnxytp2JoRzznMTT+lSjH0/EMdkvcsqbGAkyVigDPkrlf9P8e4qY+EWC42mSiltkeICaoOh+IQPb1Ej6CVYSGkHV+zNb/xw+182WlnMLOa9/Tv4"""

ActiveWorkbook.Names.Add Name:="EPMWorkbookOptions_2", RefersToR1C1:= _

"=""9F3OxBOtzB60hFONCeryveGHd9WJr+7iO45h/1l2AQAA"""

[former_member186338]

Please correct tag! Primary tag has to be:

EPM Add-In for Excel

[former_member591760]

Exactly what I was looking for. Thank you Vadim.

Were the API's not accessible through the addin help feature within Excel? I remember seeing these in the past but I'm guessing we lost that option somewhere along the way during an upgrade.

[former_member186338]

Now you have to use WEB help on help.sap.com or download pdf file:

https://help.sap.com/doc/ee389f0974631014a7da368fb0e91070/10.0.31/en-US/EPMofc_10_user_en.pdf