Solved: Microsoft Internet Controls Library

[enrique63]

Hi, How do you add the Microsoft Internet Controls to your available references?

I don't see it listed under Tools/Refences. The program below worked for me once but running it doesn't do anything anymore.

[vba]Sub SetRefs()
Dim ObRef
On Error Resume Next
' Adds Internet Controls Ref
ThisWorkbook.VBProject.References.AddFromGuid "{EAB22AC0-30C1-11CF-A7EB-0000C05BAE0B}", 1, 1
End Sub[/vba]

Thanks!

[enrique63]

Found the solution at:
http://www.mrexcel.com/forum/showthr...a+extract+html

In the VB Editor, got to Tools/Reference, then browse to:
C:\WINDOWS\system32\shdocvw.dll