html - VBA: What to reference for "htmlfile"?

Question

I found the lines

Set xmlHttp = CreateObject("MSXML2.XMLHTTP")
Set html = CreateObject("htmlfile")

and want to use them in my code. Only I like intellisense and option explicit, so I quickly modified the first one to

'needs tools>references>microsoft xml, v5.0
Dim xmlHttp As MSXML2.xmlHttp: Set xmlHttp = New MSXML2.xmlHttp

My question is: how do i do the same thing for the second line? What do I need to reference to be able to write

dim html as htmlfile

?

Answer 1

Go to Tools > Reference > Search for Microsoft HTML Object Library > tick the checkbox > OK

Now you can define html document element using early binding like below

Dim html As HTMLDocument

Using late binding you can use below which creates html document element.

Set html = CreateObject("htmlfile")