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 vote145 views1 answer
Vba compile error object required
VBA
0 vote157 views1 answer
Send webhook vbscript
VBA
3 votes181 views1 answer
Extract word in a text in excel
VBA
0 vote208 views2 answers
Excel vba store array and write to sheet
VBA
0 vote221 views1 answer
Excel vba add reference programmatically
VBA
0 vote238 views1 answer
Application.ExecutablePath VB.NET
VBA
0 vote172 views1 answer
Vba table header name
VBA
0 vote188 views1 answer
Vba foreach 2d array
VBA
0 vote158 views1 answer
Excel vba formatconditions range
VBA
0 vote166 views1 answer
Excel vba automatic calculation
VBA