Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

8 Answers

  • May 22, 2017 at 06:10 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • May 22, 2017 at 06:07 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 22, 2017 at 10:22 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 24, 2017 at 10:22 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 22 at 11:52 AM

    Hi Bruce.

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

    Thanks.

    Gavin

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 06 at 05:08 PM

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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 22 at 05:30 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 10 at 01:00 PM

    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>

    Add comment
    10|10000 characters needed characters exceeded

    • 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