ExcelToCI 登录连接到PeopleSoft的方式

最新推荐文章于 2024-10-17 10:16:42 发布

原创最新推荐文章于 2024-10-17 10:16:42 发布 · 420 阅读

0 ·

CC 4.0 BY-SA版权

Excel to CI 专栏收录该内容

5 篇文章

订阅专栏

本文介绍了一个用于构建特定格式登录链接的PublicFunction。该函数接收多个参数，包括服务器地址、门户名称等，并结合这些参数生成完整的登录请求字符串。

Public Function buildLogin(sServer As String, sPortal As String, sNode As String, sHTTPPort As String, sProtocol As String, sPSSiteName As String, sUserID As String, sPassword As String, sCIName As String, sLanguageCD As String)
Login.sCIName = sCIName
Login.sUserID = sUserID
Login.sPassword = sPassword
sProtocol = Sheets(sSheet2).btnProtocol.Value
sLogin = sProtocol & "://" & sServer & ":" & sHTTPPort & "/psc/" & _
sPSSiteName & "/" & sPortal & "/" & sNode & "/s/"
sRequest = sLogin & "WEBLIB_SOAPTOCI.SOAPTOCI.FieldFormula.IScript_SOAPToCI" & _
"?&languageCd=" & sLanguageCD & "&disconnect=y&postDataBin=y"
End Function