Enable Trust Access to VBA Object Model through SendKeys Excel Spanish version

[ABCWork]

Hi,


I am working on excel file that enabled VBA Object Model Through SendKeys for all English language users, SendKeys are not working for Users with Office Spanish version. I am hoping if anyone help in translating SendKeys to spanish version? I have placed my code snippets below.

Public Sub EnableTrustAccess()
Dim i As Integer
Dim strkeys As String
On Error Resume Next
    Do While i <= 2 'try to sendkeys 3 times
    DoEvents
        Sleep 100
    DoEvents
        If Application.LanguageSettings.LanguageID(msoLanguageIDUI) = 1033 Then 'English Version
            strkeys = "%tms%v{ENTER}" 'Enable trust access to vba project object model
        Else 'Spanish Version
            strkeys = "????"     'enable trust access to vba project object model
        End If
        
        Call SendKeys(Trim(strkeys)) 
        DoEvents
        Sleep (100)
        i = i + 1
    Loop
End Sub

 

[alansidman]

crossposted https://www.excelforum.com/excel-pr...l-through-sendkeys-excel-spanish-version.html

 

[Joe4]

While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule #13 here along with the explanation: Forum Rules). This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

 

[ABCWork]

I am marking this question as solved as I donot want to get any cross-posted response again, kudos to alan and joe.

 

[Joe4]

I was just alerting you to our policy.

If you are sure to mention any threads that you may Cross-Post in the future, and provide links to them, you won't get those kind of responses.

Thanks