
In this blog I have assumed the user is comfortable with Visual Basic and creating VBA macros in Excel.

The list of RFC enabled Function Modules in SAP can be obtained from the table TFDIR and set condition FMODE = ‘R’. To access SAP from Excel, SAP GUI client must be installed on the pc.Īlso only RFC (Remote Function Call) enabled functions can be called by External Applications.
Visual basic for excel commands how to#
In this Blog, we will see how to call standard RFC enabled SAP function modules and custom Function Modules using VBA. SAP has provided BAPIs which can be used to access SAP functions from Non SAP applications like Excel, VB, Java and C++. Accessing SAP Functions from Excel using Visual Basic Applications.
