ActiveX error - Calling RFC from Excel (VBA Macro)

swathi_aragula — Mon, 22 Apr 2019 13:59:52 GMT

Hello Experts,

I am working towards uploading an excel into SAP and execute a RFC. This Excel is working as expected in a Windows 7, but not working on Windows 10. I am new to Macros scripting, founds few solutions online but nothing seems to help to resolve this error.

I have checked the compatability issue, the Windows 10 system is 64 bit processor, Excel is also being processed on 64 bit and VBA is also running on 64 bit processor.

I am using the below libraries (As I found these are the solution for this error) -

sapfewse.ocx (SAP GUI Scripting API)
wdtaocx.ocx (SAP Table Factory)
wdtlog.ocx (SAP Logon Control)
wdobapi.ocs (SAP BAPI Control)
wdtfunc.ocx (SAP Remote Function Call Control)

None of these libraries are helping, the error is basicallt on any createobject statements such as,

Set objBAPIControl = CreateObject(“SAP.Functions”)
Set LogonControl = CreateObject(“SAP.LogonControl.1”)
Set Functions = CreateObject(“SAP.Functions”)
Set TableFactory = CreateObject(“SAP.TableFactory.1”)
Set objConnection = LogonControl.NewConnection

Please advise, how I can avoid this error and proceed further.

Thanks,

Swathi

Re: ActiveX error - Calling RFC from Excel (VBA Macro)

former_member186338 — Mon, 22 Apr 2019 14:15:00 GMT

Strange idea to add not related tag:

EPM Add-In for Excel

Just because of the word "Excel"???

topic ActiveX error - Calling RFC from Excel (VBA Macro) in Application Development and Automation Discussions

ActiveX error - Calling RFC from Excel (VBA Macro)

Re: ActiveX error - Calling RFC from Excel (VBA Macro)