{"id":1157,"date":"2007-03-28T14:51:00","date_gmt":"2007-03-28T19:51:00","guid":{"rendered":"http:\/\/blogs.devhorizon.com\/reza\/?p=1157"},"modified":"2007-03-28T14:51:00","modified_gmt":"2007-03-28T19:51:00","slug":"get-excel-to-use-soap-to-communicate-with-wss-30","status":"publish","type":"post","link":"https:\/\/blogs.devhorizon.com\/reza\/2007\/03\/28\/get-excel-to-use-soap-to-communicate-with-wss-30\/","title":{"rendered":"Get Excel to use SOAP to communicate with WSS 3.0"},"content":{"rendered":"<p><P>I have seen quite a few cases that any call to method <STRONG>&#8216;Post&#8217; <\/STRONG>of different objects such as&nbsp;&nbsp;<STRONG>&#8216;IOWSPostData&#8217;<\/STRONG>&nbsp; (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&nbsp;follow these steps :<?xml:namespace prefix = o ns = \"urn:schemas-microsoft-com:office:office\" \/><o:p><\/o:p><\/P><br \/>\n<P>1) Go to C:Program FilesMicrosoft OfficeOffice121033 <BR>2) Open the Excel Add-In EXPTOOWS.XLA <BR>3) Find Intialize() method <BR>4) In Initialize mthod comment out that lVer = Application.SharePointVersion(URL)<BR>5) Add the line lVer=2&nbsp; instead<o:p><\/o:p><\/P><br \/>\n<P>Your Intialize() method should now look like this:<o:p><\/o:p><\/P><br \/>\n<P><BR>Sub Initialize(List, Title, URL, QuickLaunch)<o:p><\/o:p><\/P><br \/>\n<P>&nbsp; strQuickLaunch = QuickLaunch<BR>&nbsp; aTarget(iPublishURL) = URL<BR>&nbsp; aTarget(iPublishListName) = List<BR>&nbsp; aTarget(iPublishListDesc) = Title<BR>&nbsp; &#8216;lVer = Application.SharePointVersion(URL)<BR>&nbsp; lVer = 2&nbsp; &#8216;Or any number greater than 2<o:p><\/o:p><\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 12pt; FONT-FAMILY: 'Times New Roman'; mso-fareast-font-family: 'Times New Roman'; mso-ansi-language: EN-US; mso-fareast-language: EN-US; mso-bidi-language: AR-SA\">End Sub&nbsp;&nbsp;<\/SPAN><BR><BR>&nbsp;<BR><\/P><br \/>\n<HR align=left width=\"50%\" noShade SIZE=10><\/p>\n","protected":false},"excerpt":{"rendered":"<p>I have seen quite a few cases that any call to method &#8216;Post&#8217; of different objects such as&nbsp;&nbsp;&#8216;IOWSPostData&#8217;&nbsp; (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 [&hellip;]<\/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"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Get Excel to use SOAP to communicate with WSS 3.0 - Reza Alirezaei&#039;s Blog %<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/blogs.devhorizon.com\/reza\/2007\/03\/28\/get-excel-to-use-soap-to-communicate-with-wss-30\/\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Reza Alirezaei\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/blogs.devhorizon.com\\\/reza\\\/2007\\\/03\\\/28\\\/get-excel-to-use-soap-to-communicate-with-wss-30\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/blogs.devhorizon.com\\\/reza\\\/2007\\\/03\\\/28\\\/get-excel-to-use-soap-to-communicate-with-wss-30\\\/\"},\"author\":{\"name\":\"Reza Alirezaei\",\"@id\":\"https:\\\/\\\/blogs.devhorizon.com\\\/reza\\\/#\\\/schema\\\/person\\\/cdbb24d283697a65951cb4a14e474938\"},\"headline\":\"Get Excel to use SOAP to communicate with WSS 3.0\",\"datePublished\":\"2007-03-28T19:51:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/blogs.devhorizon.com\\\/reza\\\/2007\\\/03\\\/28\\\/get-excel-to-use-soap-to-communicate-with-wss-30\\\/\"},\"wordCount\":198,\"commentCount\":0,\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/blogs.devhorizon.com\\\/reza\\\/2007\\\/03\\\/28\\\/get-excel-to-use-soap-to-communicate-with-wss-30\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/blogs.devhorizon.com\\\/reza\\\/2007\\\/03\\\/28\\\/get-excel-to-use-soap-to-communicate-with-wss-30\\\/\",\"url\":\"https:\\\/\\\/blogs.devhorizon.com\\\/reza\\\/2007\\\/03\\\/28\\\/get-excel-to-use-soap-to-communicate-with-wss-30\\\/\",\"name\":\"Get Excel to use SOAP to communicate with WSS 3.0 - Reza Alirezaei's Blog %\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/blogs.devhorizon.com\\\/reza\\\/#website\"},\"datePublished\":\"2007-03-28T19:51:00+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/blogs.devhorizon.com\\\/reza\\\/#\\\/schema\\\/person\\\/cdbb24d283697a65951cb4a14e474938\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/blogs.devhorizon.com\\\/reza\\\/2007\\\/03\\\/28\\\/get-excel-to-use-soap-to-communicate-with-wss-30\\\/\"]}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/blogs.devhorizon.com\\\/reza\\\/#website\",\"url\":\"https:\\\/\\\/blogs.devhorizon.com\\\/reza\\\/\",\"name\":\"Reza Alirezaei's Blog\",\"description\":\"Blogging from the field!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/blogs.devhorizon.com\\\/reza\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/blogs.devhorizon.com\\\/reza\\\/#\\\/schema\\\/person\\\/cdbb24d283697a65951cb4a14e474938\",\"name\":\"Reza Alirezaei\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/3ba940d84e0ecb909e62e93df4c56daf0395c7e53c914467ab2ee73124a7d7b6?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/3ba940d84e0ecb909e62e93df4c56daf0395c7e53c914467ab2ee73124a7d7b6?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/3ba940d84e0ecb909e62e93df4c56daf0395c7e53c914467ab2ee73124a7d7b6?s=96&d=mm&r=g\",\"caption\":\"Reza Alirezaei\"},\"url\":\"https:\\\/\\\/blogs.devhorizon.com\\\/reza\\\/author\\\/rezaa\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Get Excel to use SOAP to communicate with WSS 3.0 - Reza Alirezaei's Blog %","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/blogs.devhorizon.com\/reza\/2007\/03\/28\/get-excel-to-use-soap-to-communicate-with-wss-30\/","twitter_misc":{"Written by":"Reza Alirezaei","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/blogs.devhorizon.com\/reza\/2007\/03\/28\/get-excel-to-use-soap-to-communicate-with-wss-30\/#article","isPartOf":{"@id":"https:\/\/blogs.devhorizon.com\/reza\/2007\/03\/28\/get-excel-to-use-soap-to-communicate-with-wss-30\/"},"author":{"name":"Reza Alirezaei","@id":"https:\/\/blogs.devhorizon.com\/reza\/#\/schema\/person\/cdbb24d283697a65951cb4a14e474938"},"headline":"Get Excel to use SOAP to communicate with WSS 3.0","datePublished":"2007-03-28T19:51:00+00:00","mainEntityOfPage":{"@id":"https:\/\/blogs.devhorizon.com\/reza\/2007\/03\/28\/get-excel-to-use-soap-to-communicate-with-wss-30\/"},"wordCount":198,"commentCount":0,"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/blogs.devhorizon.com\/reza\/2007\/03\/28\/get-excel-to-use-soap-to-communicate-with-wss-30\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/blogs.devhorizon.com\/reza\/2007\/03\/28\/get-excel-to-use-soap-to-communicate-with-wss-30\/","url":"https:\/\/blogs.devhorizon.com\/reza\/2007\/03\/28\/get-excel-to-use-soap-to-communicate-with-wss-30\/","name":"Get Excel to use SOAP to communicate with WSS 3.0 - Reza Alirezaei's Blog %","isPartOf":{"@id":"https:\/\/blogs.devhorizon.com\/reza\/#website"},"datePublished":"2007-03-28T19:51:00+00:00","author":{"@id":"https:\/\/blogs.devhorizon.com\/reza\/#\/schema\/person\/cdbb24d283697a65951cb4a14e474938"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/blogs.devhorizon.com\/reza\/2007\/03\/28\/get-excel-to-use-soap-to-communicate-with-wss-30\/"]}]},{"@type":"WebSite","@id":"https:\/\/blogs.devhorizon.com\/reza\/#website","url":"https:\/\/blogs.devhorizon.com\/reza\/","name":"Reza Alirezaei's Blog","description":"Blogging from the field!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/blogs.devhorizon.com\/reza\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/blogs.devhorizon.com\/reza\/#\/schema\/person\/cdbb24d283697a65951cb4a14e474938","name":"Reza Alirezaei","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/3ba940d84e0ecb909e62e93df4c56daf0395c7e53c914467ab2ee73124a7d7b6?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/3ba940d84e0ecb909e62e93df4c56daf0395c7e53c914467ab2ee73124a7d7b6?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/3ba940d84e0ecb909e62e93df4c56daf0395c7e53c914467ab2ee73124a7d7b6?s=96&d=mm&r=g","caption":"Reza Alirezaei"},"url":"https:\/\/blogs.devhorizon.com\/reza\/author\/rezaa\/"}]}},"_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}]}}