|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
Sub 百度地图搜索()
Dim objson As Object, StrJs As String, url As String, p
Cells.Clear
[a1:c1] = [{"店名","地址","电话"}]
Set objson = CreateObject("scriptcontrol")
objson.Language = "javascript"
For p = 1 To 1000
url = "http://map.baidu.com/?newmap=1"
url = url & "&reqflag=pcmap"
url = url & "&biz=1"
url = url & "&pcevaname=pc2"
url = url & "&da_par=direct"
url = url & "&from=webmap"
url = url & "&qt=s"
url = url & "&from=webmap"
url = url & "&c=119"
url = url & "&wd=ktv"
url = url & "&pn=" & p - 1
url = url & "&db=0"
url = url & "&sug=0"
url = url & "&da_src=pcmappg.poi.page"
url = url & "&on_gel=1"
url = url & "&src=7"
url = url & "&gr=3"
url = url & "&l=13"
url = url & "&addr=0"
url = url & "&nn=" & (p - 1) * 10
url = url & "&ie=utf-8"
url = url & "&t=1428490938134"
With CreateObject("msxml2.xmlhttp")
.Open "GET", url, False
.send
StrJs = "var a=" & .responsetext & ";var s=''; for(x in a.content){ s+=a.content[x].name+'\t'+a.content[x].addr+'\t'+a.content[x].tel+'\r';};"
StrJs = objson.Eval(StrJs)
End With
With CreateObject("new:{1C3B4210-F441-11CE-B9EA-00AA006B1A69}")
.SetText StrJs
.PutInClipboard
End With
With ActiveSheet
.Cells(Rows.Count, 1).End(xlUp).Offset(1).Select
.Paste
End With
Next p
End Sub
Private Sub TextBox1_Change()
End Sub
哪位大神帮忙看看,我想搜索整个东莞的KTV,搜出来只有552个,而在百度上搜索应该是815个。是不是哪里设置错了,导致有些没有搜索到?? |
|