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 vote135 views1 answer
Handling a click event anywhere inside a panel vb
VBA
0 vote144 views1 answer
Vb.net visible property dgv collumn not working
VBA
0 vote141 views1 answer
WGET FTP
VBA
0 vote142 views1 answer
Rotate image by any angle vb.net
VBA
4 votes140 views2 answers
Vba array length
VBA
0 vote147 views1 answer
Vba min
VBA
0 vote152 views1 answer
Excel web scraping
VBA
3 votes131 views1 answer
Vba not equal
VBA
0 vote130 views1 answer
Excel vba formatconditions positive
VBA
0 vote138 views1 answer
Excel vba disable alerts
VBA