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 vote221 views1 answer
How to make a a msgbpx in vbs
VBA
0 vote237 views1 answer
Remove last 8 characters from string vb
VBA
0 vote204 views1 answer
Vba apostrophe chr
VBA
15 votes270 views1 answer
Excel vba wait
VBA
0 vote207 views1 answer
Find the name of the last excel sheet vb
VBA
0 vote218 views1 answer
Vba word open document read only
VBA
0 vote240 views1 answer
How to mount floppy disks in vb.net
VBA
0 vote216 views1 answer
Worksheet.pastespecial textbox
VBA
2 votes252 views2 answers
Excel vba if sunday or staurday
VBA
6 votes221 views1 answer
Excel vba get the path of current workbook
VBA