源碼網(wǎng) vba中怎么通過(guò)鏈接獲取網(wǎng)頁(yè)源碼?
vba中怎么通過(guò)鏈接獲取網(wǎng)頁(yè)源碼??jī)煞N方法,一是使用AJAX,二是開(kāi)啟IE進(jìn)程,我推薦用方法一,我的例子代碼如下:Dim http Set http = CreateObject("Microsof
vba中怎么通過(guò)鏈接獲取網(wǎng)頁(yè)源碼?
兩種方法,一是使用AJAX,二是開(kāi)啟IE進(jìn)程,我推薦用方法一,我的例子代碼如下:
Dim http Set http = CreateObject("Microsoft.XMLHTTP") http.Open "POST", "連接地址", False http.send "" If http.Status = 200 Then selection.text=http.responseText End If