|
发表于 2016-1-28 13:01
|
显示全部楼层
本楼为最佳答案
本帖最后由 xdragon 于 2016-1-28 13:13 编辑
- Sub aliexpress()
- Dim arr, re, i As Long
- arr = Range("C3:C" & Cells(Rows.Count, "C").End(xlUp).Row).Value
- ReDim re(1 To UBound(arr), 1 To 1)
- With CreateObject("MSXML2.XMLHTTP")
- For i = 1 To UBound(arr)
- If arr(i, 1) <> "" Then
- .Open "GET", "http://www.aliexpress.com/wholesale?catId=0&SearchText=" & arr(i, 1), False
- .send
- re(i, 1) = Split(Split(.responsetext, "resultCount"":""")(1), """")(0)
- End If
- Next
- End With
- Range("D3").Resize(UBound(re)) = re
- End Sub
复制代码 请测试。。。 |
|