Skip to Content
Former Member
Feb 21, 2017 at 08:40 PM

SAP Logon Using Excel VBA MS Office 64-Bit (Win 10)

4148 Views Last edit Feb 22, 2017 at 01:20 AM 5 rev


i'm using MS Excel 2013 and Win 7 to Logon to SAP with VBA (SAP 740 Final Release, Version 7400.

Code Below:

Sub SAPCon()
    Dim R3 As Object
    Set R3 = CreateObject("SAP.Functions")
    ZSID = "XYZ"
    Dim myFunc1, QUERY_TABLE1, RowCount1 As Object
    Set myFunc1 = R3.Add("RFC_READ_TABLE")
    If R3.Connection.Logon(0, True) <> True Then
        MsgBox "Cannot Log on to SAP"
        Exit Sub
    End If
End Sub

But when using Win 10 and MS Excel 2016 (64-Bit), I've got error:

Any different VBA Code to Logon to SAP using Win 10 and Office 2016 (64-Bit)?

Since I can't roll back the windows and MS Office installation because of IT Division policy in our company.

I can't also download activex or dll file and register it to the machine (IT Division policy) -

Thank You.