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.