There's another tool called OLEVIEW.EXE that ships with Visual Studio, but it basically gives you the RAW view of what your seeing with the Visual Basic Editor ... they both read the same COM typelibs but VBA at least gives you a nicer interface and easier navigation ...Internet Explorer you say, eh ?
OK, here a small "teach a man to fish" kinda tutorial on performing your own COM discovery ...
The only peice of information you have is the "ProgID" and for internet explorer, we know that is "internetexplorer.application". So go into regedit.exe and do the following initial steps:
1) Start regedit
2) Open HKEY_CLASSES_ROOT
3) Find InternetExplorer.Application
4) Open up that key and click CLSID
5) Should say default="{0002DF01-0000-0000-C000-000000000046}"
6) Double-click "default" and ^C the CLSID into your clipboard buffer
7) Go all the way back up to the top of HKEY_CLASSES_ROOT again.
8) Find a key called HKEY_CLASSES_ROOT\CLSID
9) Crack it open and hit ^F (find) then ^V the CLSID into the dialogbox and press "Find Next"
10) Crack it open and check out "LocalServer32" (for DLL's, the key is called InprocServer32") Internet Explorer is a .exe localserver. But we're here to check out a key called "TypeLib" - check out the default value of that.
11) The default data value should say "{EAB22AC0-30C1-11CF-A7EB-0000C05BAE0B}". This is the CLSID of the typelib that describes the interface in all it's gory details ... select this value into your clipboard buffer. We're not done yet.
12) In HKEY_CLASSES_ROOT\CLSID search for this typelib class id ... when you find it, you should see a new reference to an InProcServer32 now - the value is:
%SystemRoot%\System32\shdocvw.dll
Whew ... now you know that the COM typelib information for the component called InternetExplorer.Application is implemented inside a DLL (as a resource) at:
%SystemRoot%\System32\shdocvw.dll
This is part one of the adventure ... if you don't want to perform the previous steps, just take things from here ... now on to Part II ...
1) Start Excel and the Visual Basic Editor.
2) Go TOOLS->REFERENCES
3) Click BROWSE on the dialog
4) Paste %SystemRoot%\System32\shdocvw.dll into the filename box
5) Click "Open" and now you should have a new reference called "Microsoft Internet Controls"
6) Click OK and go VIEW->Object Browser
7) Select SHDocVW and you should see a class called "InternetExplorer" under classes. Select it.
8) Look in the right pane - look familiar ?
Hope this helps.
-Shawn