Error connecting from excel to sap in automatic mode

Former Member — Wed, 17 Oct 2007 09:31:28 GMT

Hi, I want to connect to sap from excel without it shows the logon screen. I use the following sentence:

If R3.Connection.logon(0, True) <> True Then

If the value of parameter is False, shows logon to me and works well, with True it gives error and it does not connect.

The object R3 has been created as

Set R3 = CreateObject("SAP.Functions")

Thanks

Re: Error connecting from excel to sap in automatic mode

Former Member — Wed, 17 Oct 2007 10:51:50 GMT

I have solved part of the problem. To skip the screen of logon, is necessary to fill up all these values

R3.Connection.System = "system"

R3.Connection.Systemnumber = "01"

R3.Connection.Client = "999"

R3.Connection.User = "user"

R3.Connection.Password = "pass"

R3.Connection.Language = "EN"

R3.Connection.Destination = "destination"

R3.Connection.hostname = "hostname"

R3.Connection.autologon = True

But my problem now is that the system r3 to that I want to connect is through citrix, and this way it causes error.

Thanks.