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
Showing results for 
Search instead for 
Did you mean: 

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

edson_suzuki
Explorer
0 Kudos

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

1 REPLY 1

Former Member
0 Kudos

Read this document !

https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/608058b4-81b7-2910-4598-8a66dcdb...

This might solve your problem

Regards,

Lalit Mohan Gupta.