title: Parsing JSON data into Excel sheet
body: <p>I'm trying to extract JSON data into Excel sheet as table by using the following code.</p>
  
  <pre><code>Sub test()
      Dim httpObject As Object
      Set httpObject = CreateObject("MSXML2.XMLHTTP")
  
      sURL = "https://www.nseindia.com/live_market/dynaContent/live_watch/stock_watch/foSecStockWatch.json"
  
      sRequest = sURL
      httpObject.Open "GET", sRequest, False
      httpObject.send
      sGetResult = httpObject.responseText
  
      Dim oJSON As Object
      Set oJSON = JsonConverter.ParseJson(sGetResult)
  
      i = 2
  
      For Each sItem In oJSON
          dItemString = oJSON(sItem)("symbol")
          sItemValue = oJSON(sItem)("open")
          vItemValue = oJSON(sItem)("high")
          xItemValue = oJSON(sItem)("low")
          Cells(i, 1) = dItemString
          Cells(i, 2) = sItemValue
          Cells(i, 3) = vItemValue
          Cells(i, 4) = xItemValue
          i = i + 1
      Next
  End Sub
  </code></pre>
  
  <p>However, I'm getting the below error!</p>
  
  <p><a href="https://i.stack.imgur.com/aHRBf.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/aHRBf.png" alt="enter image description here"></a></p>
  
  <p><a href="https://i.stack.imgur.com/hI1pa.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/hI1pa.png" alt="enter image description here"></a></p>
  
  <p>Why I'm getting this error? Kindly advise</p>