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 vote184 views1 answer
Vba foreach 2d array
VBA
13 votes288 views2 answers
Vba write text file
VBA
0 vote147 views1 answer
Type excel.application is not defined vb
VBA
0 vote157 views2 answers
Vb.net include quotes in string
VBA
3 votes152 views1 answer
Excel vba last row in range
VBA
0 vote158 views1 answer
Vba sort the data Z to A
VBA
0 vote147 views1 answer
Vba get relative cell address
VBA
3 votes163 views1 answer
Vba post request json
VBA
0 vote148 views1 answer
Backspace key has stopped working visual studio
VBA
0 vote156 views1 answer
VBA Loop to range
VBA