Unable to create SharePoint list from Excel
Hello.
When trying to import an Excel file into SharePoint I get the following error message:
Method 'post' of object 'iowspostdata' failed
Every solution iv 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
publishForm.Show
If publishForm.returnCode.Caption = "0" Then
PublishToOWS = 0
Else
PublishToOWS = publishForm.returnCode.Caption
End If
Exit Function
PublishToOWS_ErrHandling:
MsgBox Err.Description, vbOKOnly, publishForm.Caption ' Handle other situations here....
Resume Next
End Function
I really hope that someone can help me with this.
Regards
Maria
August 17th, 2012 6:39am