Sapass

 Simplify SAP R/3 development with Excel VBA/VB RFC  
Home> Sap_Active_X

Index
Log on by Function Control
Log on by Logon Control
Create Structure 1
Create Structure 2
Create Table
Call SAP RFC Function 1
Call SAP RFC Function 2 (Dynamic)

VBA/VB ActiveX and SAP RFC
We check the syntax for calling SAP RFC function module from VBA/VB.

17-Sep-2005


Log on by Function Control
Most simple way to logon to SAP is to go with ActiveX object. This utilizes the ActiveX module in :...SAP/FrontEnd/Controls/wdtfuncs.OCX.

Move to 'Log on by Function Control'


Log on by Logon Control
Same as to go with Function, you can logon with Logon object. But some of the methods are only available in the Function object so it's better to go along with Function object. This utilize the ActiveX module in ...SAP/FrontEnd/Controls/wdtlog.OCX. This actually nothing different from the one in Function object.

Move to 'Log on by Logon Control'


Create Structure 1
There are several ways to create SAP structure. Here, we will be checking how we can obtain table structure information from SAP and create structure on Excel VBA/VB. Use CreateStructure method.

Move to 'Create Structure 1'


Create Structure 2
This is an alternative for creating structure. We will use Table factory method here.

Move to 'Create Structure 2'


Create Table
Same as NewStructure method, Table can be created by the NewTable method of TableFactory control. This utilize the ActiveX module in ...SAP/FrontEnd/Controls/WDTAOCX.OCX.

Move to 'Create Table'


Call SAP RFC Function 1
Here we will check how we can call SAP RFC enabled function module from VBA/VB. This utilize the ActiveX module in ...SAP/FrontEnd/Controls/wdtfuncs.ocx.

Move to 'Call SAP RFC Function 1'


Call SAP RFC Function 2 (Dynamic)
Alternate syntax for calling SAP RFC Function from VBA/VB. We will see different syntax for calling.

Move to 'Call SAP RFC Function 2 (Dynamic)'


 
 Link to Blog... VB/VBA

Sapass