Skip to Content
avatar image
Former Member

CONVERT TO FORMULA ANALYSIS for Excel in VBA BPC10.1

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!

capture.png (1.2 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    Dec 13, 2016 at 01:12 PM

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

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 13, 2016 at 12:08 PM

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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 13, 2016 at 12:51 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 14, 2016 at 06:22 PM

    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

    Add comment
    10|10000 characters needed characters exceeded