如何通过vba宏将excel文件上传到jive上？

Question

我必须通过vba宏上传jive上的excel文档。请让我知道是否可以通过REST API或任何其他方法

Answer 1

在VBA中以命令行模式使用Jive应用程序可以做到这一点。联系您的Jive人员，将此信息发送给您。首先，您必须下载此应用程序并将其安装到您的系统中，然后您必须通过Shell命令使用参数调用此应用程序。

我使用了下面的代码来完成这个任务。

Public Sub ShellCmd()

    Dim strExe As String, strJiveInstanceURL As String, strFilePattern As String
    Dim usrID As String, Passwd As String, strcurlExtra As String

    strExe = "The Jive exe file path"
    strJiveInstanceURL = "https://companyname.jiveon.com"
    strFilePattern = "c:/santosh/Test1.xlsx"
    usrID = "***" ' your user ID
    Passwd = "*******" ' your password
    strcurlExtra = "-x http://gateway.****.***:1234 --proxy-user your user       ID:Your password -k" ' proxy server settings

    Call Shell("""" & strExe & """" & " " & """" & strJiveInstanceURL & """" & " " & """" & _
strFilePattern & """" & " " & "test" & " " & """ """ & " " & """" & "99743" & """" & _
" " & "1 userID Password" & " " & """" & strcurlExtra & """", vbNormalNoFocus)

End Sub