This is the Internet Explorer category.

This category includes topics such as IE automation for purposes of web scraping or programmatically navigating through websites for purposes of VBA usage.


Automation iconExcel iconInternet Explorer iconVBA icon

Internet Explorer Automation Object Library – Update for Excel 2007

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

Excel School