本文深入探讨了使用VBA进行网络GET请求的方法，通过创建Msxml2.ServerXMLHTTP.6.0对象，设置请求头并发送请求，最终获取网页响应内容。此教程适合希望在Excel中实现网络数据抓取的开发者。
Private Function HttpGet(ByVal URL As String, ByVal Cookie As String) As String
Dim HTTP As Object
Set HTTP = CreateObject("Msxml2.ServerXMLHTTP.6.0")
HTTP.open "GET", URL, False
HTTP.SetRequestHeader "Cookie", Cookie
HTTP.send
HttpGet = HTTP.responseText
'Debug.Print HttpGet
End Function
vb6发送带cookie的get请求
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
