1,502
社区成员
发帖
与我相关
我的任务
分享
Sub getSingleSeoData() '获取网页数据
'获取网页数据-chinaz
Dim HTTPREQ As Object
Set HTTPREQ = CreateObject("MSXML2.XMLHTTP.3.0")
HTTPREQ.Open "GET", "http://seo.chinaz.com/?q=bbs.csdn.net", False
HTTPREQ.Send
Do Until HTTPREQ.ReadyState = 4
DoEvents
Loop
Cells(1, 1).Value = HTTPREQ.responseText
'获取网页数据-baidu
HTTPREQ.Open "GET", "http://www.baidu.com/s?wd=site%3Abbs.csdn.net", False
HTTPREQ.Send
Cells(1, 2).Value = HTTPREQ.responseText
Set HTTPREQ = Nothing
End Sub
Sub 宏1()
With ActiveSheet.QueryTables.Add(Connection:= _
"URL;http://www.baidu.com/s?wd=site%3Axadsyy.com&rsv_spt=1&issp=1&rsv_bp=0&ie=utf-8&tn=baiduhome_pg&rsv_sug3=8&rsv_sug=0&rsv_sug4=281&rsv_sug1=5&inputT=9313" _
, Destination:=Range("$B$1"))
.Name = _
"s?wd=site%3Axadsyy.com&rsv_spt=1&issp=1&rsv_bp=0&ie=utf-8&tn=baiduhome_pg&rsv_sug3=8&rsv_sug=0&rsv_sug4=281&rsv_sug1=5&inputT=9313"
.FieldNames = True
.RowNumbers = False
.FillAdjacentFormulas = False
.PreserveFormatting = True
.RefreshOnFileOpen = False
.BackgroundQuery = True
.RefreshStyle = xlInsertDeleteCells
.SavePassword = False
.SaveData = True
.AdjustColumnWidth = True
.RefreshPeriod = 0
.WebSelectionType = xlEntirePage
.WebFormatting = xlWebFormattingNone
.WebPreFormattedTextToColumns = True
.WebConsecutiveDelimitersAsOne = True
.WebSingleBlockTextImport = False
.WebDisableDateRecognition = False
.WebDisableRedirections = False
.Refresh BackgroundQuery:=False
End With
End Sub
Sub getSingleSeoData()
Dim HTTPREQ As Object
Set oDoc = CreateObject("htmlfile")
Set HTTPREQ = CreateObject("MSXML2.XMLHTTP.3.0")
HTTPREQ.Open "GET", "http://www.baidu.com/s?wd=site%3Abbs.csdn.net", False
HTTPREQ.Send
oDoc.body.innerHTML = HTTPREQ.responseText
Cells(1, 2).Value = Split(Split(oDoc.All.tags("p")(0).innertext, "个")(0), "数")(1)
Set HTTPREQ = Nothing
End Sub
Sub getSingleSeoData() '获取网页数据
'获取网页数据-chinaz
Dim HTTPREQ As Object
Set oDoc = CreateObject("htmlfile")
Set HTTPREQ = CreateObject("MSXML2.XMLHTTP.3.0")
HTTPREQ.Open "GET", "http://seo.chinaz.com/?q=bbs.csdn.net", False
HTTPREQ.Send
Do Until HTTPREQ.ReadyState = 4
DoEvents
Loop
oDoc.body.innerHTML = HTTPREQ.responseText
Cells(1, 1).Value = oDoc.body.innertext
'获取网页数据-baidu
HTTPREQ.Open "GET", "http://www.baidu.com/s?wd=site%3Abbs.csdn.net", False
HTTPREQ.Send
oDoc.body.innerHTML = HTTPREQ.responseText
Cells(1, 2).Value = oDoc.body.innertext
Set HTTPREQ = Nothing
End Sub