Thomas,
You could pass the logon credentials through macros if required... there was some discussion on this .. look up threads by Peter Knoer on VBA Scripting in Excel.. will also try and find out similar posts in the meanwhile... One of my colleagues had done something similar..
With Run("sapbex.xla!sapbexGetConnection") ' call the connection
' Set the params for Auto logon
.client = "100"
.user = STR_SAP_USERID
.Password = STR_SAP_PWD
'.Language = "YOUR LANGUAGE YOU LIKE TO USE FOR QUERY DISPLAY ( i.E. "EN")"
.SystemNumber = "<your system number>" '
.ApplicationServer = STR_SAP_PWD
.UseSAPLOgonIni = False 'important for automatic connection
.logon 0, True ' This will provide a dialog to appear
Arun
Hope it helps..
Add a comment