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 vote172 views1 answer
Vb test if reference is null
VBA
1 vote176 views1 answer
Vbs run
VBA
0 vote174 views1 answer
Convert number to minutes in vba
VBA
0 vote162 views1 answer
How to use VBA to add new record in MS Access?
VBA
1 vote179 views2 answers
Excel vba password protect
VBA
1 vote159 views1 answer
Excel vba get ordinal number from cardinal number
VBA
1 vote161 views1 answer
Add control vb
VBA
0 vote198 views2 answers
Get unique random number in vb.net
VBA
0 vote162 views1 answer
Vba string
VBA
1 vote169 views1 answer
Add a index column power bi
VBA