Sapass - Simplify SAP R/3 development with Excel VBA/VB RFC


Sapass	Simplify SAP R/3 development with Excel VBA/VB RFC


	Home> Sap_Active_X>Log on by Logon Control

Index

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.

(A) Example of VBA/VB macro code

Sub TempLogon4()

Dim objLogon As Object 'Logon control
Dim sapConn As Object
Set objLogon = CreateObject("SAP.LogonControl.1") 'Create ActiveX object

Set sapConn = objLogon.NewConnection
If sapConn.Logon(0, False) <> True Then 'Try Logon
MsgBox "Cannot log on to SAP"
End If

End Sub

(B) Properties for Connection object

Events	Long	Enables or disables events triggered by the control tloDisableAllLogonEvents = 0 tloEnableOnClick = 1 tloEnableOnLogoff = 2 tloEnableOnError = 4 tloEnableOnCancel = 8 tloEnableAllLogonEvents = 32767 *All can be combined.
Caption	String	Text on the button.
BackColor	Color	Background color of the button.
hWnd	HWND	Window handle of the button.
Enabled	Enabled	Enables the button.
Font	Font	Font of button text.
Parent	HWND	Window handle of parent window.
Default	Boolean	Button Default pushbutton.
ApplicationName	String	Name of the application that uses the Logon control, used to identify connections.
System	String	SAP system name.
ApplicationServer	String	Application server name.
SystemNumber	Long	System number.
MessageServer	String	Message server name.
GroupName	String	Group name.
TraceLevel	Long	Debug on/off.
RfcWithDialog	Long	Connection go through SAP GUI. *Any other values than 0 will be treated as "On". (Read/Write)
Client	String	Logon client.
User	String	Logon user.
Language	String	Logon Language.

17-Sep-2005


Link to Blog... VB/VBA		Sapass