tag:blogger.com,1999:blog-5445783528576714897.post5502424692865739949..comments2023-07-14T11:25:14.658+01:00Comments on IT's Kris Haynes: Method 'post' of object 'IOWSPostData' failedKris Hayneshttp://www.blogger.com/profile/00967281415343721704noreply@blogger.comBlogger5125tag:blogger.com,1999:blog-5445783528576714897.post-11170450396437991522013-07-23T14:44:58.933+01:002013-07-23T14:44:58.933+01:00Thanks for this tip!! It was due to the excel filt...Thanks for this tip!! It was due to the excel filters Regishttp://www.rboussion.frnoreply@blogger.comtag:blogger.com,1999:blog-5445783528576714897.post-25497898911646573972012-07-17T10:15:58.220+01:002012-07-17T10:15:58.220+01:00It's a bit of an old post, but for completenes...It's a bit of an old post, but for completeness, I fixed "The Selected range cannot be converted to a list before publishing or the existing table is invalid" by selecting Format as Table first. On a similar theme, if you get HTTP 403 errors try renaming C:\Program Files\Microsoft Office\Office12\OWSSUPP.DLL.Anonymoushttps://www.blogger.com/profile/09371176598494571506noreply@blogger.comtag:blogger.com,1999:blog-5445783528576714897.post-20521305825301713062012-06-18T19:34:03.347+01:002012-06-18T19:34:03.347+01:00This works, ThanksThis works, ThanksAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-5445783528576714897.post-6363221449161824272009-09-24T21:21:10.307+01:002009-09-24T21:21:10.307+01:00Microsoft may have attempted to fix this -- here i...Microsoft may have attempted to fix this -- here is the subroutine from my EXPTOOWS.XLA:<br /><br />Sub Initialize(List, Title, URL, QuickLaunch)<br /> strQuickLaunch = QuickLaunch<br /> aTarget(iPublishURL) = URL<br /> aTarget(iPublishListName) = List<br /> aTarget(iPublishListDesc) = Title<br /> lVer = -1 ' can't tell STS server version<br /> If Val(Application.Version) >= 12 Then<br /> lVer = Application.SharePointVersion(URL)<br /> End If<br />End Sub<br /><br />Later in code is:<br /><br />If lVer >= 2 Or lVer = -1 Then<br /> On Error GoTo 0<br /> On Error GoTo Publish_ErrHandling<br /> ' From now on, we use new soap method to publish list to sharepoint list . . .<br /><br />Blah, blah, blah<br /><br />Guess what? Their attempted fix doesn't work. I am still getting the IOWSPostData error.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5445783528576714897.post-60695608340904027862009-08-14T15:39:11.199+01:002009-08-14T15:39:11.199+01:00I was a able to fix the problem "The Selected...I was a able to fix the problem "The Selected range cannot be converted to a list before publishing or the exisiting table is invalid" by removing the filters before importing.Anonymousnoreply@blogger.com