title: How to get the code for reading JSON file into Excel using VBA code?
body: <p>How can I get the code for reading JSON file into Excel using VBA code? Note: Output Response have already captured and stored in sResponse variable.</p>
  <p><strong>VBA Code:</strong></p>
  <pre><code>Dim item As Variant
  Dim jsonObject As Object
  Dim ws As Worksheet
  Set ws = Worksheets(&quot;Result&quot;)
  Dim i As Long
  i = 3
  Set jsonObject = JsonConverter.ParseJson(sResponse)
  For Each item In jsonObject(&quot;data&quot;)(&quot;judgementSummary&quot;)
  ws.Cells(i, 3) = item(&quot;result&quot;)
  ws.Cells(i, 4) = item(&quot;wording&quot;)
  i = i + 1
  Next
  </code></pre>
  <p><strong>Sample JSON Response:</strong></p>
  <pre><code>{&quot;judgements&quot;:[
  &quot;id&quot;: &quot;142555&quot;
  &quot;date&quot; : &quot;636363&quot;
  &quot;policynumber&quot;: &quot;5364fhfh&quot;
  &quot;judgementSummary&quot;:[
  { &quot;code&quot; : &quot;253&quot;
  &quot;result&quot; : &quot;3&quot;
  &quot;wording&quot; : &quot;general&quot;
  }]]}}```
  </code></pre>