I wrote about this technology some time back at Pulse Infomatics. Using the Microsoft Internet Controls, the HTMLDocument object, and VBA, you can read and extract data from almost any website.
This can be used to periodically look for changes on a website or pull data for use into your own analysis tool. We’ve had several clients use us to build tools on this technology.
A little over a month ago, a reader – unable to get the sample code working – asked if I would provide a fully working database. If that interest you, you may download that database from the Pulse site.
If you have questions about it, please feel free to ask. And let me know if you are successful in using it for your own needs.