Is it possible to automate the login to SAP Business Objects Web Services using the Analysis for Microsoft Excel COM add-in in Excel? When I run my code, I am presented with the below "Logon to SAP BusinessObjects BI Platform" window requiring a user to manually enter their web services credentials (note: these are not the same as their SAP credentials). Ideally, I would be able to set all fields (user, password, web service URL, System, and Authentication) without any user interaction.
I am attempting to automate the refresh of Excel workbooks connected to SAP Business Objects using VBA code. From reviewing the developer documentation available on SAP (see here), I am able to automate most commands. There is also a command "SAPLogon", but this is only able to provide the SAP logon credentials, not the web service ones.
A sample of my code is below:
'Refresh dashboard
LResult = Application.Run("SAPExecuteCommand", "PauseVariableSubmit", "Off")
LResult = Application.Run("SAPSetRefreshBehaviour", "On")
LResult = Application.Run("SAPExecuteCommand", "Refresh")
If LResult = 0 Then
'Refresh failed. Exit with error.
StrMsg = "Unable to retrieve variables or refresh any data; script will now exit. Please close Excel, open a new instance of Analysis for Microsoft Excel, and try again."
LogMsg StrMsg
MsgBox StrMsg
GoTo Exit_UpdateDashboard
End If
Prior to executing this block of code, I am hoping to automate the user login. I have extensively researched this and cannot find any examples of someone automating the web service login through VBA. Some of the links I've tried so far are:
SAPLogonfunction only allows you to connect to SAP systems, not to BIP. There is no option to provide the URL or authentication type. - ƘɌỈSƬƠƑ