SharePoint XML list To Excel

[Chance1234]

Ive been looking at sharepoint and importing a list via VBA,

I have got as far as

1) getting the UID of the feed and using owssvr.dll to get the XML ie something like

http://xxxxxx/_vti_bin/owssvr.dll?XMLDATA=1&List={DF6233A4-xxxx-45F9-xxxxx-214B79596495}

2) referencing microsfot XML , V5

3) creating a new domdocument

4) load XML and pass the string

and now im stuck

If i use the text property i do get the full file;
I can also pull out First and Lastchild names which returns (surprisE!) xml

I think its the schema being in the file that is throwing me a bit,

If i try use documentelelemnt.childnodes , i cant seem to get down to the nexdt node

if i try use selecting singlenode , again i cant seem to move.

does anyone have any experience of working with sharepoing in VBA ?

 

[Humphrey]

Depending on your version of SharePoint there are easier ways to that import.
Open the list so it is the only thing visible in the window. Click on the Actions tab and select Export to Spreadsheet. It will create a linked view of the list that can be updated simply by right-clicking on the returned data and choosing refresh.
No need to reinvent the wheel