Community
Application Development and Automation 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
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

ActiveX error - Calling RFC from Excel (VBA Macro)

swathi_aragula
Explorer

‎2019 Apr 22 2:59 PM

0 Likes
1,843

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

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

Reply
1 REPLY 1
Read only

former_member186338
Active Contributor

‎2019 Apr 22 3:15 PM

884

Strange idea to add not related tag:

EPM Add-In for Excel

Just because of the word "Excel"???