The error message --Method 'Post' of object 'IOWSPostData' failed --appears when I import a spreadsheet in the Create -Import Spreadheet menu of MOSS 2007.
Importing lists from Excel 2007 returns a Method 'Post' of object 'IOWSPostData' failed dialog. The problem is not with the sharepoint but result of a failed Application.SharePointVersion() call in the Excel Add-In which results in Excel attempting to use the IOWSPostData.Post() method to publish the Excel range which is used with SharePoint Services.
By forcing the version lookup result variable to 2 or greater, Excel will use SOAP to communicate with SharePoint and the publish request will be successful.
To make this change, Please follow these steps:
1. open the Excel Add-In EXPTOOWS.XLA locate in
C:\Program Files\Microsoft Office\Office12\1033.
2. Press Alt+F11 to display the Visual Basic code editor and search (Ctrl+F) for the line lVer = Application.SharePointVersion(URL).
3. Comment out that line with a single quote and add the line lVer=2 so your Intialize() method should now look like this:
Sub Initialize(List, Title, URL, QuickLaunch)
strQuickLaunch = QuickLaunch
aTarget(iPublishURL) = URL
aTarget(iPublishListName) = List
aTarget(iPublishListDesc) = Title
'lVer = Application.SharePointVersion(URL)
lVer = 2
End Sub
If you have any doubts or queries regarding the above procedure then please let me know...
I hope the above information will helps you to resolve your issue..Thanks !!
Reff:http://social.technet.microsoft.com/forums/en-US/sharepointgeneral/thread/75b2be6b-44df-4389-bf34-c7a01c12372c/
Importing lists from Excel 2007 returns a Method 'Post' of object 'IOWSPostData' failed dialog. The problem is not with the sharepoint but result of a failed Application.SharePointVersion() call in the Excel Add-In which results in Excel attempting to use the IOWSPostData.Post() method to publish the Excel range which is used with SharePoint Services.
By forcing the version lookup result variable to 2 or greater, Excel will use SOAP to communicate with SharePoint and the publish request will be successful.
To make this change, Please follow these steps:
1. open the Excel Add-In EXPTOOWS.XLA locate in
C:\Program Files\Microsoft Office\Office12\1033.
2. Press Alt+F11 to display the Visual Basic code editor and search (Ctrl+F) for the line lVer = Application.SharePointVersion(URL).
3. Comment out that line with a single quote and add the line lVer=2 so your Intialize() method should now look like this:
Sub Initialize(List, Title, URL, QuickLaunch)
strQuickLaunch = QuickLaunch
aTarget(iPublishURL) = URL
aTarget(iPublishListName) = List
aTarget(iPublishListDesc) = Title
'lVer = Application.SharePointVersion(URL)
lVer = 2
End Sub
If you have any doubts or queries regarding the above procedure then please let me know...
I hope the above information will helps you to resolve your issue..Thanks !!
Reff:http://social.technet.microsoft.com/forums/en-US/sharepointgeneral/thread/75b2be6b-44df-4389-bf34-c7a01c12372c/
