Showing results for 
Search instead for 
Did you mean: 

Login language in BEx with VBA

Former Member
0 Kudos

Hello Experts!

I want to translate texts I write in the footer by VBA. Looks like this:


MyTable1.PageSetup.LeftFooter = "&""Arial,Standard""&8" & <my text in langu 1>.</i>

Now, i want to have the text depending on the login language.

I tried this:

<i>Dim myConnection As Object

Dim myLangu As String

Set myConnection = Run("SAPBEX.XLA!SAPBEXgetConnection")

myLangu = myConnection.Language</i>

But myLangu is always empty.

Does anyone know why or maybe a better way to do this?

Best Regards,


Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Peter,

It seems that if the user opens the workbook from the SAP GUI (RRMX), that the entries will be blank.

Another way to determine the user's language preference is to read it from the System Registry.

See this thread ...

Hope it helps.

- Pete