VBA code to select multiple variables in SAP AfO

[Cime14]

Hi all,

I am trying to write a VBA code which would populate variables in SAP Analysis for Office prompts window.
With the code I am using now is only possible to change one variable line (example: SetReportingUnit = Application.Run("SAPSetVariable", "Select FCRSCode-Child(s) Opt", "XX1", "INPUT_STRING", "DS_1")) but I would like to populate two or more lines which would be at the end reflected in prompt window as on below picture (XX1 and XX2).

Any idea?

VBA code:
Sub UpdateData()

Dim SetPeriod As Long
Call Application.Run("SAPSetRefreshBehaviour", "Off")
Call Application.Run("SAPExecuteCommand", "PauseVariableSubmit", "On")
SetReportingUnit = Application.Run("SAPSetVariable", "Select FCRSCode-Child(s) Opt", "XX1", "INPUT_STRING", "DS_1")

End Sub

SAP Analysis for Office prompt window (variables selector):

 

[sancarn]

Necro thread but there is an INPUT_STRING_AS_ARRAY which will probably do what you need!

I.E.

Application.Run("SAPSetVariable", "Select FCRSCode-Child(s) Opt", Array("XX1","XX2"), "INPUT_STRING_AS_ARRAY", "DS_1"))