How to get system information from SAP BexAnalyzer 7.0 with VBA

[former_member481926]

Hi community,

does anyone know how to get SAP System Informations with VBA in Excel from the BEx Analyzer 7.0.

We try to get the used language with VBA after a user login in the SAP BexAnalyzer and we did not find a solution.

Between the login every user has to insert "de" (german) or "en" (english) to get the master data in the correct language and we need this language information in VBA for a special coding.

We try to use the BEx connection object, but it is empty when a user logged in over the standard SAP way (over the Bex Analyzer), it only works when we log into the SAP System with VBA (then the connection object is filled with data).

[dzmitrydrazdou]

Try the BExApplication object, .ComConnection.Language property. BTW, there are a lot of useful things there. At least it works when I logon to BEx via Connect button. For example:

Public BExApp As Object

Sub BExAppTest()
    Set BExApp = CreateObject("com.sap.bi.et.analyzer.api.BExApplication")
    MsgBox BExApp.ComConnection.Language
    Set BExApp = Nothing
End Sub

P.S. BExApplication object is a part of BExApi.tlb library (if you need a reference, however it seems to work even without a ref).