title: Retrieve data from the web using Excel
body: <p>I've spent hours scouring the net for anything to do with VBA calling data from the web in excel and nothing provides a tutorial on how to do so, only complicated examples un-related to what I want to do.</p>
  
  <p>I want to pull data from either a .html or .xml site, doesn't matter, via Excel and find specific points in that data. I can find specific points but don't know how to get the data or scroll through multiple lines. I've done this exact sort of thing in mIRC (sort of C code).</p>
  
  <p><a href="http://eve-central.com/home/quicklook.html?typeid=438" rel="nofollow noreferrer">http://eve-central.com/home/quicklook.html?typeid=438</a><br>
  <a href="http://api.eve-central.com/api/quicklook?typeid=438" rel="nofollow noreferrer">http://api.eve-central.com/api/quicklook?typeid=438</a><br>
  Those are two examples, using roughly the same data I'd like to retrieve. It'd be FAR more specific with at most 100 or so different values.</p>
  
  <p>I'd like to be TAUGHT how to do it, not given the code to do it, or if you must explain each part with comments in-depth please.<br>
  Edit: I'm just saying here that I don't want you to link me some random code that does something similar and expect me to modify it without an explanation. Not wanting someone to just write up a full guide of internet capability for Excel.</p>
  
  <p>Thanks
  Nick</p>
  
  <p>Edit: I'll try explaining it again in a different sense. I play a game called EVE Online, and there's a lot of "market" databases online that <strong>allow</strong> access in this form for programs to extract data of certain items' prices. Pretty much I want to do that in an Excel document and then obviously list them in a hidden sheet or something. I don't want to have to use a secondary program, I know it's entirely possible within just Excel.</p>