Analysis (AO) VBA variable update

[Former Member]

Hi,

I have multiple workbooks with Multiple data sources in each of them that need to be updated on a monthly basis.

The majority of the prompts stay the same but need to update the period for all data sources as the months go by.

Below a view of my Prompts screen with technical names included.

I would like to open the workbooks with a VBA code and then automatically let the code change the period, then refresh the data and save the workbook.

The opening part and saving part is easy but for some reason I'm not getting the variables to change with the code.

Below the code I've been playing with. Would really appreciate if someone can help me out.

Public Sub UpdateData()
Dim SetPeriod As Long

Call Application.Run("SAPSetRefreshBehaviour", "Off")
Call Application.Run("SAPExecuteCommand", "PauseVariableSubmit", "On")

SetPeriod = Application.Run("SAPSetVariable", "[0P_FISCPER3]Posting Period", 6, "DS_1")

Call Application.Run("SAPExecuteCommand", "PauseVariableSubmit", "Off")
Call Application.Run("SAPSetRefreshBehaviour", "On")

SetPeriod = Application.Run("SAPExecuteCommand", "RefreshData", "DS_1")

End Sub

Thanks in advance.

[reyemsaibot · Accepted solution]

Hi,

when I look into the SAPSetVariable command it looks like this

ret = Application.Run("SAPSetVariable", "0COUNTRY", "DE", "INPUT_STRING", "DS_1")

When I now look at your code, I miss "INPUT_STRING" or "KEY" or "TEXT" etc. and your variable also is not correct. Please fix this and look into the user guide then it should work.

best regards,

Tobias