excel - VBA - Loop specific childnodes from XML code -
i'm trying scrape following xml excel sheet. however, want loop through specific childnodes show name , priceeffectivestart , priceeffectiveend , price , , currency each index summary. xml code <indexprices> <indexpricesummary> <id>1</id> <uri>www.example.com</uri> <index> <id>3</id> <name>same day index</name> <uri>www.example.com.xml</uri> </index> <priceeffectivestart>2015-06-26</priceeffectivestart> <priceeffectiveend>2015-06-26</priceeffectiveend> <price> <amount>2.4806</amount> <currency>cad</currency> </price> <duration>1</duration> <quantitytraded> <amount>474</amount> <unit>gj</unit> <contractunit>day</contractunit> </quantit