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 vote240 views1 answer
Programmatically copy data from one workshet to another excel
VBA
0 vote238 views1 answer
Vba copy file
VBA
0 vote243 views1 answer
Vba sort multiple columns
VBA
0 vote222 views1 answer
Excel vba disable keyboard input
VBA
0 vote233 views1 answer
Search combobox items vb.net
VBA
3 votes234 views1 answer
Vba double quote
VBA
1 vote2K views1 answer
Vba Remove Case Sensitivity
VBA
5 votes243 views1 answer
Excel vba low word from Long Integer
VBA
0 vote217 views1 answer
Get current year vb
VBA
0 vote258 views1 answer
Vba dictionary length
VBA