Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

ActiveX error - Calling RFC from Excel (VBA Macro)

swathi_aragula
Explorer
0 Kudos

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) -

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

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

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

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

Thanks,

Swathi

1 REPLY 1

former_member186338
Active Contributor

Strange idea to add not related tag:

EPM Add-In for Excel

Just because of the word "Excel"???