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 vote144 views1 answer
How to make a if statement with vbs
VBA
0 vote195 views1 answer
Vbnet find highest value in chart
VBA
18 votes277 views3 answers
Excel-vba make integer
VBA
0 vote183 views1 answer
Create new worksheet excel visual basic
VBA
0 vote210 views1 answer
Excel vba protect sheet
VBA
0 vote189 views2 answers
Excel vba close without saving
VBA
0 vote213 views1 answer
Vba remove last vbcrlf
VBA
0 vote200 views1 answer
Add text to combobox drop down vb
VBA
1 vote185 views1 answer
Excel vba hide zero values
VBA
0 vote208 views2 answers
Vba remove line breaks
VBA