Unable to create SharePoint list from Excel RRS feed

  • Question

  • Hello.

    When trying to import an Excel file into SharePoint I get the following error message:
    Method 'post' of object 'iowspostdata' failed

    Every solution i´v reed tells me to change the EXPTOOWS.XLA
    Researching on-line it says to add a piece of code and comment out another piece of code.
    That lines doesn't exist in my EXPTOOWS.xla.

    (and i found the file  EXPTOOWS.XLA in C:\Program Files (x86)\Microsoft Office\Office14\1053)

    The Code in my EXPTOOWS.XLA look likes this:

    Function PublishToOWS(List, Title, URL, QuickLaunch) As Variant
        On Error GoTo PublishToOWS_ErrHandling
        publishForm.Initialize List, Title, URL, QuickLaunch
        If publishForm.returnCode.Caption = "0" Then
            PublishToOWS = 0
            PublishToOWS = publishForm.returnCode.Caption
        End If

        Exit Function
        MsgBox Err.Description, vbOKOnly, publishForm.Caption ' Handle other situations here....
        Resume Next
    End Function

    I really hope that someone can help me with this.



    Friday, August 17, 2012 10:34 AM