Skip to Content
0
Jun 14, 2018 at 02:41 PM

AfO: Save data from datasource in active sheet

850 Views

Hi all,

I'm working in a BPC embedded project in which we have a AfO book with many sheets and multiples datasources in each one.

We are using VBA code in order to save data from the datasources inserted in the active sheet, with the following code:

Sub Save()

Dim lresult As Long
Application.ScreenUpdating = False

If ActiveSheet.Name = "ABCD" Then

lresult = Application.Run("SAPExecuteCommand", "PlanDataSave", "DS_24", "DS_25")

Else

......

End If

However, the code appears not to work since its saving data from all datasources inserted in the book.

Is there any way to save data from a single datasource o some selected ones instead of saving all of them?

Thank you in advance.

Kind regards,

Adrián S.