Chance1234
New Member
- Joined
- May 6, 2002
- Messages
- 5
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 ?
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 ?