Skip to Content
0
Former Member
Apr 23, 2013 at 09:45 AM

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

400 Views

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.

Attachments

debug.jpg (23.7 kB)