PDA

View Full Version : Solved: Microsoft Internet Controls Library



enrique63
06-02-2010, 11:59 AM
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.

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

Thanks!

enrique63
06-02-2010, 03:17 PM
Found the solution at:
http://www.mrexcel.com/forum/showthread.php?t=465667&highlight=vba+extract+html

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