BEx Workbooks with language dependent Buttons

In the BEx Analyzer, buttons are not language dependent.

Here is a simple technique to dynamically change the texts of the buttons:

1) Determine the logon language.

Dim R3 As Object

Set R3 = Run(“BExAnalyzer.xla!sapBEXgetConnection”, 0)
If R3.logon(0, True) = True Then
MsgBox R3.Language
End If
2) Do a loop over an excel range containing BUTTON ID, Text FR, Text NL
For each entry modify the text with a command similar to ¬† ¬†ActiveSheet.Shapes(“BUTTON_5”).TextFrame.Characters.Text = “Test”

 

Leave a Reply