Skip to Content

Save button is not working in Analysis for Office workbook

I created a save data button in my workbook by using the following code:

Sub savePlanData() IResult = Application.Run("SAPExecuteCommand", "PlanDataSave") End Sub

It is a copy of SAP's code, but when I tried to run it, it not working. After debug the code, I notice that the value for Application.Run("SAPExecuteCommand", "PlanDataSave") is 0 instead of 1.

Anybody know how to fix it?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Mar 29, 2017 at 06:40 AM

    Hi,

    you wrote a dot and not a comma between "SAPExecuteCommand" and "PlanDataSave". Can you change this and test it again?

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 29, 2017 at 11:51 PM

    Sorry, it is a comma in my original code,

    Add comment
    10|10000 characters needed characters exceeded