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 vote220 views1 answer
Select case vba
VBA
0 vote215 views1 answer
Vba copy paste value only
VBA
0 vote233 views1 answer
Remove series name from legendvbnet
VBA
0 vote240 views1 answer
VB Error Code BC30201
VBA
3 votes239 views1 answer
Vba double quote
VBA
0 vote235 views1 answer
How to get value from clipboard in vbnet
VBA
3 votes229 views1 answer
Excel vba change format of cell
VBA
0 vote233 views1 answer
Vbs
VBA
0 vote245 views1 answer
Excel web scraping
VBA
2 votes235 views1 answer
Excel vba check if string entirely numeric
VBA