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 vote404 views1 answer
If statement vdhl
VBA
0 vote345 views1 answer
Vba like with wildcard
VBA
0 vote365 views1 answer
VBA is form loaded
VBA
1 vote378 views1 answer
Excel how to format bytes as KB, MB, GB
VBA
0 vote346 views1 answer
Vba simple quote
VBA
0 vote324 views1 answer
Add Formula to Shape Text in VBA
VBA
0 vote381 views1 answer
Excel named range sum
VBA
0 vote315 views1 answer
Excel vba arrondir
VBA
3 votes402 views1 answer
Vba continue for each loop
VBA
1 vote372 views2 answers
Get all column names from excel vba
VBA