I have seen quite a few cases that any call to method ‘Post’ <\/STRONG>of different objects such as ‘IOWSPostData’<\/STRONG> (IOWSPostData.Post()) in Excel returns with failed dialog.One of the most frequent cases is when you try to import a list from an existing Excel file. This has nothing to do with WSS 3.0 but rather the result of a failed call in the Excel Add-in which results in Excel using the IOWSPostData.Post() method to publish the Excel range or query. These post calls have been around since SharePoint Team Services 1.0 days, so if you want to change it to a soap call instead follow these steps : 1) Go to C:Program FilesMicrosoft OfficeOffice121033 Your Intialize() method should now look like this: strQuickLaunch = QuickLaunch End Sub <\/SPAN> I have seen quite a few cases that any call to method ‘Post’ of different objects such as ‘IOWSPostData’ (IOWSPostData.Post()) in Excel returns with failed dialog.One of the most frequent cases is when you try to import a list from an existing Excel file. This has nothing to do with WSS 3.0 but rather the result […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-1157","post","type-post","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/blogs.devhorizon.com\/reza\/wp-json\/wp\/v2\/posts\/1157","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blogs.devhorizon.com\/reza\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blogs.devhorizon.com\/reza\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blogs.devhorizon.com\/reza\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/blogs.devhorizon.com\/reza\/wp-json\/wp\/v2\/comments?post=1157"}],"version-history":[{"count":0,"href":"https:\/\/blogs.devhorizon.com\/reza\/wp-json\/wp\/v2\/posts\/1157\/revisions"}],"wp:attachment":[{"href":"https:\/\/blogs.devhorizon.com\/reza\/wp-json\/wp\/v2\/media?parent=1157"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blogs.devhorizon.com\/reza\/wp-json\/wp\/v2\/categories?post=1157"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blogs.devhorizon.com\/reza\/wp-json\/wp\/v2\/tags?post=1157"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\n
2) Open the Excel Add-In EXPTOOWS.XLA
3) Find Intialize() method
4) In Initialize mthod comment out that lVer = Application.SharePointVersion(URL)
5) Add the line lVer=2 instead
\n
\n
Sub Initialize(List, Title, URL, QuickLaunch)
\n
aTarget(iPublishURL) = URL
aTarget(iPublishListName) = List
aTarget(iPublishListDesc) = Title
‘lVer = Application.SharePointVersion(URL)
lVer = 2 ‘Or any number greater than 2
\n
<\/P>
\n
<\/p>\n","protected":false},"excerpt":{"rendered":"