Skip to Content
author's profile photo Former Member
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 a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

9 Answers

  • Posted on 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 a comment
    10|10000 characters needed characters exceeded

  • Posted on 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 a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on 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 a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on 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


    vba-error.jpg (22.0 kB)
    vba-references.jpg (107.0 kB)
    vba-code.txt (1.9 kB)
    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 22, 2018 at 11:52 AM

    Hi Bruce.

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

    Thanks.

    Gavin

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Mar 06, 2018 at 05:08 PM

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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 22, 2018 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 a comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 10, 2018 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 a comment
    10|10000 characters needed characters exceeded

  • Posted on Nov 04, 2019 at 09:36 AM

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

    Thanks for all

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.