How to reference shdocvw?

[MartinL]

I found this info in order to reference the "shdocvw" object, but the
"Microsoft Internet Controls" option doesn't appear in the dialog box. Is
there another way to reference it directly? I am running Excel 2003 SP3.
I did a Search for "shdowvw" in my pc and found several shdocvw.dll files in
different folders, like in C:WINDOWS\system32 for example. Can I reference
this directly? if so how?

"The References dialog box lists all the objects available to Visual Basic.
You access the dialog box by selecting Tools/References from the menu bar.
Figure 3-5 shows the References dialog box with a reference set to the
Internet Explorer object library. The proper reference is described in the
dialog box as "Microsoft Internet Controls." "

Thanks in advance.

 

[Gary Brown]

- Get into the VBE (Visual Basic Editor)
- From the top menu, select TOOLS > REFERENCES...
- Select the 'Browse' button on the right side of the window.
- Browse to 'C:\Windows\system32\shdocvw.dll' and select it.
- Hit OK

 

[MartinL]

I got help form user AB in another forum, who suggested I find "Microsoft
Browser
Helper" in the list, I did find it and now the "Microsoft Internet Controls"
option also appears. I don't know how that worked but it did.

Thanks!