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

1 vote287 views1 answer
Excel vba hide zero values
VBA
5 votes357 views1 answer
Xlvba double quotes in string literal
VBA
0 vote308 views1 answer
Vba get application version
VBA
0 vote307 views1 answer
Remove frist letter from string vbnet
VBA
0 vote307 views1 answer
Vb run command
VBA
3 votes316 views1 answer
Vba http request json
VBA
1 vote306 views2 answers
Vba string to date
VBA
0 vote308 views1 answer
Remove series name from legendvbnet
VBA
0 vote328 views1 answer
Excel vba urlmon
VBA
3 votes289 views1 answer
Excel vba last row in range
VBA