i'm using MS Excel 2013 and Win 7 to Logon to SAP with VBA (SAP 740 Final Release, Version 7400.3.11.11.28).
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) -