title: SharePoint Lists, GetListItems, XML, and VBA - I just want to crossreference!
body: <p>I have a SharePoint list with, among other things, two columns that I care about; in Excel-ese, I want to match value X in column 1, and return the corresponding value in column 2. I'm able to use a <i>variant</i> of code at <a href="http://guruj.net/node/63" rel="nofollow noreferrer">http://guruj.net/node/63</a> to retrieve the information (I think), so I think my problem focuses on navigating XML in VBA without downloaded DLLs (I do have a pile of MSXML?.DLLs, 2, 2.6, 3, 4, 5, 6).</p>
  
  <p>The closest MSDN articles I find reference .NET (I'm stuck in the VBA/VB6? that comes with Office 2003) or a downloadable DLL.</p>
  
  <p>Nat's response below outlines most of what I've found or need <i>but</i> like what I've found it's in the wrong language and part of my problem is finding search terms. I've mucked together some of a translation, for example, XMLDocument seems to be DOMDocument, but the XML parts are IXMLDOMNode or similar.</p>
  
  <p>The major problem I'm running into at the moment is that I'm getting type mismatch on the SOAP call to perform the query, or object does not support that method when I try recasting the players (listQuery, listViewFields, listQueryOptions). I've left various parts as variant, and then cast them as the type returned (since I have no SP specific library "referenced", I'm doing this a little blind) and gotten mismatches.</p>
  
  <p>It almost seems like it'd be worlds easier to screen scrape for the text.</p>