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 vote257 views1 answer
Vbnet round to nearnest thousand
VBA
0 vote223 views1 answer
Vbnet line graph smooth lines
VBA
0 vote366 views2 answers
VB
VBA
0 vote239 views1 answer
Excel vba hide columns
VBA
0 vote282 views1 answer
VBA Sort RossetaCode
VBA
0 vote261 views1 answer
Programmatically copy data from one workshet to another excel
VBA
0 vote232 views1 answer
Vba add spaces
VBA
0 vote260 views1 answer
Build an index all files of a FTP site
VBA
4 votes236 views1 answer
Excel vba how to reset usedrange
VBA
0 vote233 views1 answer
Excel vba disable mouse click
VBA