CONVERT TO FORMULA ANALYSIS for Excel in VBA BPC10.1

[former_member322611]

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

capture.png

Thank all!

[former_member186338 · Accepted solution]

Looks like there is no documented VBA interface to perform the functionality of "Convert to Formula"

[former_member322611]

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

[former_member186338]

There is no API with the functionality of this button 😞

[former_member186338]

You can try:

Press Alt

You will see letters on the ribbon

Type required letters to finally press the required button. Remember the sequence of letters

Then use in VBA:

SendKeys "%", True ' ALT key
SendKeys "(Y1)", True 
...

Not a perfect solution but the button will be pressed.

[former_member322611]

Thank you!

This is very usefull.

[former_member186338]

Unfortunately this is not a universal solution - will work only for Excel with the same number of custom tabs in the ribbon...

[Former Member]

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

[former_member186338]

Sorry, but where did you found this button? How it's related to BPC NW?

[Former Member]

Its for BPC Embedded 10.1. Analyis for Office.