Call RFC from VBA?

[m03046]

Hello,

is there a possibilty to make RFC-Calls from Visual Basic for Applications( e.g. from a Excel-Makro)without having to ininstall addtional Software on a PC beside the normal SAP-GUI?

 

[Kissel]

Hi.

What 'bout SAP DCOM connector? It can inpose a COM+ interface, so you can use it anywhere you can imagine.

Regards.

 

[mbergman]

Hello,
Since 2.4 (and maybe prior), the SAP function editor (SE37) will generate a complete C or VB program to interact with the SAP function from either Unix or a workstation. The workstation only needs the RFC lib installed. Here are the choices in SE37:
RFC_ANSIC_CL_EXP EN Complete ANSI C client example
RFC_ANSIC_SR_EXP EN Complete ANSI C server example
RFC_MSVB_CL_EXP EN Complete Vis.Basic client exa.
RFC_MSVB_SR_EXP EN Complete Vis.Basic server exa.
SAP also has downloadable examples of Excel code that will retreive customer master (KNA1) and the like from R/3.
Mike

 

[StephenBurr]

SAP DCOM Connector can definitely be used for this. I've found it to be fast and reliable.
It's also free (I think!)

 

[prosa]

Hi m03046,

you can try to see the examples and source code that SAP
gives.
You have this information with the SAPGui installation.

Check for directory ..SAPgui\rfcsdk\ccsamp\RFCSamp.VB in your program files.
There you will find examples for C/C++ and VB.

Regards

Prosa