Internet Explorer Automation Object Library - Update for Excel 2007
April 29, 2008 – 1:30 am by JP
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
Print This Post
|
Email This Post
|
Permalink
|
Subscribe now!
Filed Under: Excel, Internet Explorer, VBA, automation
Tags: automation, Internet Explorer, object library
This post has 71 views since April 29, 2008 – 1:30 am.
2 Responses to “Internet Explorer Automation Object Library - Update for Excel 2007”
These references are not part of any Office library, but show all possible libraries installed on a computer. These may or may not be appropriate for a version of Office.
Microsoft Internet Controls (C:\Windows\system32\shdocvw.dll) is different from Microsoft browser Helpers (C:\Windows\system32\browseui.dll). The former contains the Internet Explorer interface, the latter seems more related to handling of multimedia content.
By Jon Peltier on Apr 29, 2008
I’m getting the impression that not much has changed in Excel 2007 (programmatically), other than the drastic user interface changes. Since I don’t have a copy I’m not able to verify. Thanks Jon.
By JP on May 1, 2008