on 2018 Sep 17 2:35 PM
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"""
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
67 | |
8 | |
8 | |
6 | |
6 | |
6 | |
6 | |
6 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.