Set BEx workbook variables using VBA (BI 7.X)

Hi gurus,

I want to set variable values in my workbook and refresh it using VBA. I am using this code:

Sub LoadData()

Sheets("Apkrovimai").Select

Run "BExAnalyzer.xla!SAPBEXsetVariables", Range("valRange")

Run "BExAnalyzer.xla!SAPBEXrefresh", True

End Sub

valRange range stucture:

ZCOMP_CODE_AUTH 4600 ZSVM_FISCPER_EX 003.2012

I tried this structure too:

ZCOMP_CODE_AUTH 1 4600 ZSVM_FISCPER_EX 1 003.2012

Problem: Code just don't work no error no nothing.

Details: I tried debugging it:

Run "BExAnalyzer.xla!SAPBEXsetVariables", Range("valRange")

goes to

Function SAPBEXsetVariables(varValues As Range) As Integer

Call pAddin.SetVariables(varValues.Value2, varValues.Application.ActiveWorkbook.Name)

End Function

and varValues.Value2 is with values:

But this gives me no clue why variables is not set.

Can someone help me with this problem?

Thanks in advance.