title: How to get value of child element from json data directly in VBA
body: <p>I have seen way where JSON data can be used to print rows in excel/macro. That answer is here - > <a href="https://stackoverflow.com/questions/33195936/how-to-convert-json-data-to-xml-data-in-excel-macro-or-vb-net/33201480#33201480">How to convert JSON data to xml data in excel macro or VB.Net</a></p>
  
  <p>But there is another issue, how can i get the value of child element <strong>People</strong> from json data so that i can get the value of data from it for further use.</p>
  
  <p>The data i am getting is like :</p>
  
  <pre><code>{"properties":{"SuccessCount":1,"PendingCount":0},"People":[{"memberId":"3","memberAge":2,"memberCount":1,"memberName":"Alex"},{"memberId":"4","memberAge":5,"memberCount":1,"memberName":"Peter"},{"memberId":"5","memberAge":2,"memberCount":1,"memberName":"Kirby"}],"TotalMembers":3}
  </code></pre>