Skip to Content
1

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

May 22, 2017 at 05:59 PM

4.6k

avatar image
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

10 |10000 characters needed characters left characters exceeded
Former Member

Hi Bruce

Do you have a solution?

Thanks

Miki

0
* Please Login or Register to Answer, Follow or Comment.

7 Answers

Matt Fraser
May 22, 2017 at 06:10 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Bartosz Jarkowski May 22, 2017 at 06:07 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member May 22, 2017 at 10:22 PM
0

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.

Show 2 Share
10 |10000 characters needed characters left characters exceeded

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

0
Former Member

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")

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

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)
Share
10 |10000 characters needed characters left characters exceeded
Pillay Gavin Jan 22 at 11:52 AM
0

Hi Bruce.

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

Thanks.

Gavin

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Mar 06 at 05:08 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member May 22 at 05:30 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded