on 12-13-2016 12:02 PM
HI!
How to execute convert to formula with VBA en analysis for microsoft excel.
I cant do that with record macro..ActiveWorkbook.Names("SAPCrosstab1").Delete
Thank all!
Looks like there is no documented VBA interface to perform the functionality of "Convert to Formula"
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
This button is in the "Analysis" tab in the top toolbar as you can see in the screenshot I attach you below. It is related to BPC NW when you open a query in ANALYSIS the data appear with its ID, and when you click on the button "convert to formula", the formula appear in the formula bar written. What we need is to know how to execute this button with VBA.
Thanks in advance,capture2.png
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Javier,
Are you deleting the crosstab with the VBA? If yes then the Convert to formula will not work.....as it works only on a cross tab...
Check this...http://help.sap.com/businessobject/product_guides/AMS11/en/11_aaoffice_user_en.pdf PG.no 13.
If not, please explain your error with a screenshot.
Regards,
JP
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Sorry, but where did you found this button? How it's related to BPC NW?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
15 | |
3 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.