利用Excel将百度地图搜索结果导出
鲍秦 2018-07-20 09:46:37 我在用Excel的宏 写了如下代码(抄了网上的)
Sub baiduMap()
Dim url, html, js
Cells.ClearContents
br = [{"店名","地址","电话"}]
Range("a1:c1") = br
url = ""
Set html = CreateObject("htmlfile")
执行到此处的时候 activex部件不能创建对象 429
Set js = CreateObject("scriptcontrol")
js.Language = "jscript"
For p = 1 To 120
With CreateObject("msxml2.xmlhttp")
url = "http://map.baidu.com/?newmap=1"
...........
...........
Next
End With
Next
End Sub
望高手能够帮忙解决