Skip to Content
0
Apr 08, 2009 at 03:10 PM

Connect SAP R3 (Single Sign On user) using Microsoft excel

665 Views

Hi people,

I'm trying to connect in SAP R3 using microsoft excel, when the user is not a single sign on the macro that execute the function to connect work correctly, but I don't get connect with user single sign on. Somebody someway get do this connection.

Excel macro

...

Set R3 = CreateObject("SAP.Functions")

R3.Connection.System = <name of system in logon pad>

R3.Connection.client = <client>

R3.Connection.user = <sap user>

R3.Connection.ApplicationServer = <application server>

R3.Connection.UseSAPLogonini = True

R3.Connection.SNCName = <SAP user SNC name>

R3.Connection.SNC = True

R3.Connection.Language = <logon language>

...

Regards

Suzuki