title: Parsing JSON in VBA strange object being returned
body: <p>I'm writing an excel program which reads a JSON string from a web service. The string contains the contents of a database view. Using some answers from this website i've been able to convert the string into an object using a script control and the evaluate funcion</p>
  
  <pre><code>set sc = new ScriptControl
  sc.Eval(sJSONString)
  </code></pre>
  
  <p>However when I examine what has been produced in the object it is arranged extremely oddly. The data has been arranged into both non-continuous (note the 99) indexes and Items in the same object. Can anyone shed any light on what is happening please? (Please do not suggest using non standard VBA libraries, I can't)</p>
  
  <p><img src="https://i.stack.imgur.com/Ekqtr.png" alt="enter image description here"></p>