How can I get JSON data out of a web page and parse it in Excel VBA
<p>My company has a web service that we use to keep track of some information.  They have built an API that allows us to get information out of it.  My group is trying to do the same.  However, the other groups have all used C# to accomplish this, and the development level of this team isn't higher than that of Excel VBA.  What I need to do:</p>

<ol>
<li>Go to a known URL <a href="http://service.company.com/Group=1" rel="nofollow noreferrer">http://service.company.com/Group=1</a></li>
<li>Get the JSON result that appears on the screen into VBA</li>
<li>Translate the JSON to readable human - <a href="https://stackoverflow.com/questions/6627652/parsing-json-in-excel-vba">This part seems to have been solved here</a></li>
</ol>

<p>The rest of the code around what I need to do, I can handle.  I'm hoping there is a JSON reader built into VBA that I can leverage for part 3.  Any help would be much appreciated.</p>

<p>EDIT:
I figured out how to get JSON information out of the web page, there was some user/password authentication required in order to get that.  So that is part 1 and 2 done.  I'm working on Part 3.  The JSON information seems to be coming out in this pattern:</p>

<pre><code>[{"Column1":value1,"Column2":value2},
{"Column1":value1,"Column2":value2}]
</code></pre>