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 vote248 views1 answer
Vba registry settings
VBA
0 vote202 views1 answer
How to self delete a vbscript file
VBA
0 vote205 views1 answer
Backspace key has stopped working visual studio
VBA
0 vote245 views1 answer
How to add line graph vb net
VBA
18 votes395 views3 answers
Excel-vba make integer
VBA
0 vote242 views1 answer
For each item in folder outlook vba
VBA
0 vote283 views1 answer
Excel vba protect worksheet without password
VBA
1 vote219 views1 answer
Vba date to unix timestamp
VBA
0 vote235 views1 answer
Excel vba convert cells address
VBA
0 vote210 views1 answer
Quit excel with save changes dialog vb.net
VBA