A
-
vba中如何读取html
VBA中读取HTML,可使用XMLHTTP或WinHttpRequest对象获取网页内容,再通过HTMLDocument对象解析。,“`vb,Dim xml As Object,Set xml = CreateObject(“MSXML2.XMLHTTP”),xml.Open “GET”, “http://example.com”, False,xml.Send,Dim html As Object,Set html = CreateObject(“HTMLFile”),html.body.innerHTML = xml.responseText