Custom Office Programming and Automation
This category includes topics such as IE automation for purposes of web scraping or programmatically navigating through websites for purposes of VBA usage.
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 »
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 »
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
Copyright © 2013 Jimmy Peña · Hosted by FutureQuest · Powered by Genesis · Legal
Follow Me