Posted by [IP Address: 193.126.85.143] 'Fred' on September 06, 2001 at 08:17:58 EST:
I'm trying to connect SAP from Excel.
Every thing is perfect but I would like to do it without the user must logon in SAP.
I've already try (think is only available for VB):
R3.connection.System = "**"
R3.connection.Applicationserver = "*****"
Sub retrieve_table_contents()
Dim R3, MyFunc, App As Object
Dim SEL_TAB, NAMETAB, TABENTRY, ROW As Object
Dim Result As Boolean
Dim iRow, iColumn, iStart, iStartRow As Integer
iStartRow = 4
Worksheets(1).Select
Cells.Clear
'**********************************************
'Create Server object and Setup the connection
'**********************************************
Set R3 = CreateObject("SAP.Functions")
R3.Connection.client = "103"
R3.Connection.user = "0lapaf"
R3.Connection.password = "**"
R3.Connection.language = "EN"
If R3.Connection.LOGON(0, False) <> True Then
Exit Sub
End If
Can you help me?