on 05-22-2017 6:59 PM
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.
Thanks
Bruce
I had the same problem. Solved Installing SAP GUI 750 Patch level 6
Thanks for all
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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>
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Same over here. I'm also very interested in your solution (if you have one).
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Bruce.
I have the same issue. How were you able to resolve it?
Thanks.
Gavin
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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:
The VBA still stops at line:
Set MyFunc = SAP.Add("Z_JE_VALIDATE")
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
95 | |
11 | |
11 | |
10 | |
9 | |
8 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.