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
Make your computer talk vbscript
VBA
0 vote197 views1 answer
Iterate all file in a folder vba
VBA
1 vote175 views2 answers
Vba function return array
VBA
0 vote197 views2 answers
Checking and changing system volume vb.net
VBA
0 vote175 views1 answer
Vbnet hex to binary
VBA
-1 vote169 views1 answer
Text to speech vb.net
VBA
0 vote189 views1 answer
Vba nested dictionary
VBA
0 vote185 views1 answer
Ribbon show/hide
VBA
0 vote182 views1 answer
Write listbox to text file vb.net
VBA
1 vote161 views1 answer
Excel vba get column name from number
VBA