The site formerly known as Code For Excel and Outlook
August 17, 2010 by · 
In previous articles I've written about how to extract information from webpages, and interact with them to navigate through a website.
This article won't strictly focus on IE, but on several collections available through the MSHTML Object Model.
Continue Reading: An exploration of IE browser methods, part III »
June 8, 2010 by · In a previous post I promised to go through a real example of how we can automate Internet Explorer to retrieve data from a website. We'll also enumerate some of the members of the IE Document Object as well as see how we can incorporate XMLHTTP into the mix.
Continue Reading: An exploration of IE browser methods, part II »
June 1, 2010 by · 
It's been a while since I posted anything related to Internet Explorer, but here is a series of VBA functions that let you automate Internet Explorer's native methods.
Continue Reading: An exploration of IE browser methods, part I »
May 28, 2008 by · In keeping with my Website XML parsing post, here is a short function that returns the body text from a webpage as a string, on which you can use other functions like Instr, Left$, Mid$, etc, to extract necessary data.
Continue Reading: XML Parsing Function »
April 29, 2008 by · One of the most popular pages on this site shows code for automating Internet Explorer. However I have only tested the code in Excel XP/2003. The purpose of this post is to credit a gentleman named Durand Sinclair who, using Excel 2007, pointed out to me that the name of the IE object library in Excel 2007 is actually called "Microsoft Browser Helper" (click Tools>References in the VBE). Once you select the checkbox, exit the dialog box and re-enter it, the name changes to "Microsoft Internet Controls".
If anyone else would like to verify this behavior in Excel 2007 and let me know, I would be grateful to hear it.
Thanks Durand!
–JP
Site last updated: February 9, 2012
Follow Me