Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Error connecting from excel to sap in automatic mode

Former Member

‎10-17-2007 10:31 AM

0 Kudos

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

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

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

The object R3 has been created as

Set R3 = <b>CreateObject("SAP.Functions")</b>

Thanks

1 REPLY 1

Former Member

‎10-17-2007 11:51 AM

0 Kudos

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

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

Thanks.