cancel
Showing results for 
Search instead for 
Did you mean: 

GUI 750 - install caused VBA RFC call to SAP to fail

Former Member

Hello all,


We have a process that uses Excel files that have VBA macro code that logs into SAP and then executes a function module by RFC to validate the data in the file.

Since installing the 750 GUI, from 740, we are experiencing an error in the VBA code because of a missing reference, "SAP Remote Function Call: COM support". The file reference it can't find is "C:\WINDOWS\system32\librfc32.dll".


I have read several notes that talk about replacing the classical RFC with NWRFC. But I haven't read anything that gives the details about how to do that. 2417687 2256415 1025361

Does anyone who has installed GUI 750 know the steps that need to be executed to get past this problem?

FYI - this is only causing me a problem, not any of the users performing this process in production. I am the only user on GUI 750 at my company.

A post in the archive asked several question that were not answered. The answers to questions 3-4, that information would be very useful.

Archive posting


Thanks
Bruce




gui-750-vba-error.png

Former Member
0 Kudos

Hi Bruce

Do you have a solution?

Thanks

Miki

Accepted Solutions (0)

Answers (9)

Answers (9)

0 Kudos

I had the same problem. Solved Installing SAP GUI 750 Patch level 6

Thanks for all

0 Kudos

Same issue here. Started to see this problem after updating to SAP Gui 7.5.

've added all ocx references to the VBA Excel project, but upon logon I receive a popup error:

SAP Logon Control:

Error Group RFC_ERROR_PROGRAM

Message: <empty>

rob_marshall
Explorer
0 Kudos

Hi Bruce, I am also having the same issues but I am getting closer to a solution. I have contacted SAP and it was suggested I install SAP GUI 7.50 patch level 5 hotfix 1. See if this helps you.

Cheers!

Rob

former_member582887
Discoverer
0 Kudos

Hi Bruce,

I have same issue like as you methioned, appricate to you if you have any progress or solution for this issue? Thanks.

Tony

sascha_mink2
Explorer
0 Kudos

Same over here. I'm also very interested in your solution (if you have one).

pillay_gavin
Explorer
0 Kudos

Hi Bruce.

I have the same issue. How were you able to resolve it?

Thanks.

Gavin

Former Member
0 Kudos

Bartosz,

This is not a VB application, rather an Excel file that has a VBA macro that logs into SAP and the executes a function module that imports a table of the data, validates it, then returns data in a new Excel sheet if there are any errors. I am attaching 3 files: an image of the VBA error, an image of the VBA references, and the code that logs into SAP, stopping on the line that caused the error.

My guess is that I am missing a reference that is needed in the code where the SAP function module is being defined.

'******** SET UP THE FM NAME AND PARAMETER OBJECTS *****

Set MyFunc = SAP.Add("Z_JE_VALIDATE") ' >> this is the line that is causing the problem

Thanks

Bruce

vba-error.jpg

vba-code.txt

vba-references.jpg

Former Member
0 Kudos

Bartosz,

I previously copied librfc32.dll from C:|...\SAPGUI\ to C:\WINDOWS\system32\. That didn't solve the "missing reference."

A VB developer here suggested that we register the file in C:\windows\SysWOW64\. That didn't solve the

"missing reference."

Matt,

Thanks for the response.

As a developer, I've never really had to deal with any of these RFC technical details. I'll talk with our Basis guy tomorrow and hopefully he has some insight that might be helpful to me.

BJarkowski
Active Contributor
0 Kudos

Try also to copy the file to the directory with the VB app.

Maybe you could register the DLL with regsrv32?

regsvr32 “path and FileName.dll”

Best regards

Bartosz

Former Member
0 Kudos

I added references based upon this blog posting, updated 5/20/2017.

https://blogs.sap.com/2015/04/21/tip-how-to-use-activex-rfc-controls-without-sap-gui-for-windows/

added:

  • wdobapiU.ocx – from directory SAP\FrontEnd\SAPgui\Unicode
  • wdtaocxU.ocx – from directory SAP\FrontEnd\SAPgui\Unicode
  • wdtfuncU.ocx – from directory SAP\FrontEnd\SAPgui\Unicode
  • wdtlogU.ocx – from directory SAP\FrontEnd\SAPgui\Unicode
  • SAPRfcWrapperU.dll – from directory Program Files (x86)\Common Files\SAP Shared

The VBA still stops at line:

Set MyFunc = SAP.Add("Z_JE_VALIDATE")

Matt_Fraser
Active Contributor
0 Kudos

Hi Bruce,

I hadn't realized the 750 GUI was out. However, I've dealt with a change to the "new" NetWeaver RFC in another context before (update of BSI TaxFactory), and what I learned there might be adaptable to this.

Basically, I found it was necessary to download the NWRFC SDK, unpack it with sapcar, then copy the files from \nwrfcsdk\lib to my working directory. In your case, my best guess is that it will be the \Program Files (x86)\SAP\FrontEnd\SAPgui folder.

For reference, I blogged about doing this for TaxFactory at https://blogs.sap.com/2016/01/21/bsi-taxfactory-cyclic-j-and-the-new-rfc-wrapper/. Scroll down to the section New RFC Library near the end of the blog.

Cheers, and hope this helps,
Matt

BJarkowski
Active Contributor
0 Kudos

Hi,

i had similar issue with SAP Service Connector (to open support connection with SAP). The solution was to copy librfc32.dll from SAP GUI directory (the file was still there!) to the application directory. Check, maybe this will work for you as well (in your case move the file to C:\WINDOWS\system32\)

Best regards

Bartosz