Vba excel parser xml

xml_document.SetProperty "SelectionNamespaces", "xmlns:sp=""http://schemas.microsoft.com/sharepoint/soap/"" 'Set the start path Set xml_nodes_collection = xml_document.SelectNodes("//soap:Envelope/soap:Body/sp:UpdateListItemsResponse/sp:UpdateListItemsResult/sp:Results/sp:Result") 'Go through all row IDs For Each xml_node_element In xml_nodes_collection row_id = xml_node_element.attributes(0).NodeValue For Each xml_child_node In xml_node_element.ChildNodes '....... Next Next

Source: excel.yocker.com

Similar codes

0 vote341 views1 answer
Vbs exec hidden
VBA
1 vote321 views1 answer
Vba compile error object required
VBA
0 vote325 views1 answer
Reset border color textbox vba
VBA
0 vote318 views1 answer
Visual basic msdos
VBA
0 vote344 views1 answer
How to mount floppy disks in vb.net
VBA
2 votes315 views1 answer
Vba array contains
VBA
0 vote325 views1 answer
Vb streamreader
VBA
0 vote362 views1 answer
Vba ternary
VBA
0 vote338 views1 answer
Arq linux
VBA
0 vote428 views1 answer
Wpf dark title bar
VBA