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 vote135 views1 answer
Sort using vba
VBA
8 votes204 views1 answer
Excel vba determine number of elements in a 2D array
VBA
4 votes127 views1 answer
Excel vba how to reset usedrange
VBA
3 votes139 views1 answer
Excel vba get the workbook full filename with path
VBA
2 votes113 views2 answers
Constructor vb.net
VBA
4 votes119 views1 answer
Excel formula for last non-empty cell in a column
VBA
3 votes122 views1 answer
Vba folderexists
VBA
22 votes260 views1 answer
Xl vba check for folder
VBA
0 vote138 views1 answer
Vbnet click on dgv cells
VBA
0 vote131 views1 answer
Add text to combobox drop down vb
VBA