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 vote239 views1 answer
Default host vbox address
VBA
0 vote226 views1 answer
Excel vba current folder
VBA
0 vote215 views1 answer
Find the name of the last excel sheet vb
VBA
3 votes271 views1 answer
Vba continue for each loop
VBA
0 vote242 views1 answer
Vbscript check if string is empty
VBA
0 vote225 views1 answer
Vba option button selected
VBA
0 vote230 views1 answer
Compare dates vb
VBA
0 vote246 views1 answer
Vbnet round to nearnest thousand
VBA
0 vote239 views1 answer
Do while not vb.net
VBA
0 vote256 views1 answer
Vba boolean to string
VBA