这个X呢?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
Debug.Print
Cells
都是有长度限制的,超长就会被截断,所以你觉得“获取信息不全”
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
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
-方法:只要数出当前页码有多少快照是“2013-11-14”的就行:
求代码,麻烦的话方法也行,真心谢谢了~
http://seo.chinaz.com/?q=nopages111111.com就是这些边界条件可能还要判断一下,最终的结果是要达到这样的,请大神过目:
其中快照隔天指的是昨天,比如今天2013-11-15,隔天就是2013-11-14
而-3就是隔天减去三天就是2013-11-11首页1就是在第一个,首页3就是在第二个,首页0就是第一页没有首页再次谢谢大神了!