title: Retrieving data from URL [Excel VBA]
body: <p>I have extensively searched and not found what i am looking for. My knowledge of VBA has so far been confined to manipulating numbers so this is a new area for me.</p>
  
  <p>I am attempting to pull the single line of data from the following url <a href="http://api.rsbuddy.com/grandExchange?a=guidePrice&amp;i=1021" rel="nofollow">LINK</a>. Once that is done, I can work on parsing that data but we'll cross that bridge...</p>
  
  <p>Here is the code so far in Excel VBA:</p>
  
  <pre><code>Enum READYSTATE
      READYSTATE_UNINITIALIZED = 0
      READYSTATE_LOADING = 1
      READYSTATE_LOADED = 2
      READYSTATE_INTERACTIVE = 3
      READYSTATE_COMPLETE = 4
  End Enum
  
  Sub ImportStackOverflowData()
  
      Dim ie As InternetExplorer
  
      Dim html As HTMLDocument
  
      Set ie = New InternetExplorer
  
      ie.Visible = False
      ie.navigate "http://api.rsbuddy.com/grandExchange?a=guidePrice&amp;i=1637"
  
      Do While ie.READYSTATE &lt;&gt; READYSTATE_COMPLETE
          DoEvents
      Loop
  
      'show text of HTML document returned
      Set html = ie.document.body
      MsgBox html.DocumentElement.innerHTML
  
      'close down IE and reset status bar
      Set ie = Nothing
      Application.StatusBar = ""
  
  End Sub
  </code></pre>
  
  <p>After navigating to the url, the IE downloads window opens, and asks me to Open or Save a .json file... clicking anything crashes the code and ignoring it leaves the code in the READYSTATE loop below it.</p>
  
  <p>How can I stop it from opening this window, and instead insert the info into the workbook?</p>
  
  <p>Thank you.</p>