Convert HTML doc to XML for xPath Parsing

[manofcheese]

I am trying to find a good way to convert an HTML document to XML so I can use an Xpath expression for parsing. As a test I'd like to get this xpath expression to pull information from What Is My IP Shows your real public IP address - IPv4 - IPv6

//*[@id="post-7"]/div[1]/div[1]/div/ul/li[2]

So far this is what I have but I haven't been able to get the response converted to XML yet.

Sub xpathTest()
Dim myURL As String
Dim strPath As String
Dim xml_obj As Object

myURL = "https://www.whatismyip.com/"
Set xml_obj = CreateObject("MSXML2.XMLHTTP")
        
xml_obj.Open "GET", myURL, False
xml_obj.Send

Set myxml = xml_obj.responseXML

strPath = "//*[@id=" & """" & "post-7" & """" & "]/div[1]/div[1]/div/ul/li[2]"


Dim dom As DOMDocument30
Dim nodelist As IXMLDOMNodeList
   
   
myxml.SetProperty "SelectionLanguage", "XPath"

Set nodelist = myxml.DocumentElement.SelectNodes(strPath)
   
Debug.Print "Found " & nodelist.Length & " Node"


Debug.Print result

End Sub

 

[CSmith]

Well HTML is not XML...

 

[manofcheese]

Well HTML is not XML...

I know that, but I also know that you can use xpath on html because they are so similar. I've done it in Python and I've used the xpath helper chrome extension to get things I need. I'm just trying to figure out a way to do this in vba

 

[CSmith]

Ok, well what information are you after because your example :

//*[@id="post-7"]/div[1]/div[1]/div/ul/li[2]

is not in the page when I visit...