title: pure vba SiteData.GetListCollection use in Excel 2010
body: <p>I need just the final step. Maybe it's stupid but .. what am i missing here?. I'm trying to get all the lists of a SharePoint site. If I debug I can see the correct tree in the locals pane, but the SelectNodes("//_sList") returns no childs ...</p>
  
  <pre><code>Sub MyTest()
  Const urlRef As String = "http://MySite/_vti_bin/SiteData.asmx"
  Dim WebRequest As New XMLHTTP60, strRequest As String
  WebRequest.Open "POST", urlRef, False
  WebRequest.setRequestHeader "Content-Type", "text/xml; charset=utf-8"
  WebRequest.setRequestHeader "SOAPAction", "http://schemas.microsoft.com/sharepoint/soap/GetListCollection"
  strRequest = _
      "&lt;?xml version='1.0' encoding='utf-8'?&gt; " &amp; _
      "&lt;soap12:Envelope xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xsd='http://www.w3.org/2001/XMLSchema' xmlns:soap12='http://www.w3.org/2003/05/soap-envelope'&gt; " &amp; _
      "  &lt;soap12:Body&gt; " &amp; _
      "    &lt;GetListCollection xmlns='http://schemas.microsoft.com/sharepoint/soap/' /&gt; " &amp; _
      "  &lt;/soap12:Body&gt; " &amp; _
      "&lt;/soap12:Envelope&gt;"
  
  WebRequest.send strRequest
  
  Dim docResponse As New DOMDocument60
  Set docResponse = WebRequest.responseXML
  
  docResponse.setProperty "SelectionLanguage", "XPath"
  Debug.Print docResponse.SelectNodes("//_sList").Length ' &gt;&gt;&gt; Returns 0!!!!
  End Sub
  </code></pre>