title: Parsing a JSON object array in Excel VBA
body: <p>I know a similar question has been asked and answered before a few times:
  <a href="https://stackoverflow.com/questions/6627652/parsing-json-in-excel-vba">Parsing JSON in Excel VBA</a>,
  <a href="https://stackoverflow.com/questions/5773683/excel-vba-parsed-json-object-loop">Excel VBA: Parsed JSON Object Loop</a></p>
  
  <p>However, the above solution doesn't work if I am trying to access an array within the returned object.  I'm receiving a JSON object from the Google Translate API in the following format:</p>
  
  <pre><code>"{
  "sentences":[
      {
          "trans":"Responsibility\n",
          "orig":"??",
          "translit":"",
          "src_translit":"Zérèn"
      },
      {
          "trans":"Department",
          "orig":"??",
          "translit":"",
          "src_translit":"Bùmén"
      }
  ],
  "src":"zh-CN",
  "server_time":86
  </code></pre>
  
  <p>}"</p>
  
  <p>I want to be able to access the two translated sentences as sentences(0) and sentences(1).  I can use the GetProperty() method from the previous posts to retrieve the sentences object, but I can't access its members because it is an object of type JScriptTypeInfo, not an array.</p>
  
  <p>I've tried to convert the sentences object to an array in JScript using something similar to the method described here: <a href="http://ramblings.mcpher.com/Home/excelquirks/snippets/scriptcontrol/arrays" rel="nofollow noreferrer">How to pass arrays between javaScript and VBA</a>.  I can only get it to return the first value of the array, for some reason.</p>
  
  <p>What would be the best way to do this?</p>