How to handle and get values from dynamic tags from xml file in VBA macro : I have an xml file with 3 levels. Some of the tags are dynamic.*(Please check below xml file)*
I have to validate whether the tag "price" is present in all nodes or not and also need to get value of "price tag". I also need to fetch a value of every node present in xml file.

**My final outcome should be like below excel file :** 

[Excel sheet output][1]

**Test XML file attached below:** 
[XML File with dynamic tags][2]

Please assist me here.


  [1]: https://i.stack.imgur.com/ZtCUc.png
  [2]: https://i.stack.imgur.com/2mCr6.png