My task is: get data from SAP via RFC call. How would you implement this with not showing the password? Maybe I shouldn't use macro?
My present solution shows password:
Set objBAPIControl = CreateObject("SAP.Functions")
Set sapConnection = objBAPIControl.Connection
With sapConnection
.Destination = "SQ1"
.ApplicationServer = "111.111.111.111"
.Client = "100"
.User = "RFC_REMOTE"
.Password = "XXX"
.Language = "EN"
.SystemNumber = "00" |