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

About JP

I'm just an average guy who writes VBA code for a living. This is my personal blog. Excel and Outlook are my thing, with a sprinkle of Access and Word here and there. Follow this space to learn more about VBA. Keep Reading »


Related Articles:


Share This Article:

Share and bookmark this articledelicious buttonfacebook buttonlinkedin buttonstumbleupon buttontwitter button

comment bubble 5 Comment(s) on Internet Explorer Automation Object Library – Update for Excel 2007:

  1. Jon Peltier writes:

    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.

  2. 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.

  3. Disco Lemonade writes:

    I have excel 2003 at work, and 2007 at home. I found that Microsoft Internet Controls wasn't automatically in my reference library in 2007, so I had to browse to C:\Windows\system32\shdocvw.dll and add it. After that, everything worked perfectly. :)

  4. Here is the Excel 2007 Microsoft Internet Controls reference of file details.
    Location: c:\windows\system32\ieframe.dll

    • If you're only trying to download a file from the Internet, you can do so without the costly overhead of automating IE.

      There's an API called URLDownloadToFile you can use to download a file from the Internet to your local computer: URLDownloadToFile.

      You can also use a web query, see Refresh Web Data into Excel Every Minute for assistance. The exact process depends on your Excel version.

This article is closed to any future comments.
learn excel dashboards