   Extract HTML data to Excel
  I'm designing a project right now that entails extracting a row of data out of a table in an html page online. After I extract the data, I want to add it to an Excel spreadsheet to update the spreadsheet. I want to pull the data everyday? I'm going to be using VB6. Is there a control I can use? Could someone push me in the general direction? Thank you.   
  There is no control but it is not hard just to write a parser that will extract the information for you.  Just study the html and look for the pattern, once you know that just write the code that reads that pattern.  Because HTML is a code it will even give you "tags" that you can search for to get in the information, should be pretty easy.theTroll   ;  if the html is well-formed, it should also be valid xml, so you could use an xml parser to extract the data.I'm pretty sure you can use vb6 to interface to msxml, but unless you have a really pressing reason to use vb6, (i.e. you've been told to by a boss/teacher) I'd ditch it. There's nothing VB6 can do that can't be done easier and cleaner in other languages.   ;  HTML is not valid XML.  Yes you can access XML through HTML but a pure XML parser would have no idea what to do with HTML code.  theTroll   ;Quote:Original post by TheTrollHTML is not valid XML.  Yes you can access XML through HTML but a pure XML parser would have no idea what to do with HTML code.  theTrollsorry, you're right. I was thinking of XHTML. There are still plenty of 3rd party HTML parsers. I would recommend python for this type of project.   ;  I'm pretty sure you can import an html page into an excel document in a very naive way.The first thing I'd try is to simply open the webpage using excel.  If that works, you should be able to automate it.   