|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
试了一个,可行,接下来看看如何批量下载了,谢谢!
Sub Main()
Const strFileName As String = "C:\Downloads\28.jpg"
With CreateObject("MSXML2.XMLHTTP") 'CreateObject("WinHttp.WinHttpRequest.5.1")
.Open "GET", "http://121.40.211.8/api/getservice?orgid=cdyxy&ObjId=m.20110919-SGD-888-0178.ft.cebx.1&UserName=cdyxy00010&MetaId=m.20110919-SGD-888-0178&cult=CN&dbsource=dlib&Time=2015-5-24 10:56:21&Sign=7D0C468211ECF0A916CD5412058B0344&Rights=1-0_00&width=1600&height=2400&page=6&ServiceType=imagepage", False
.Send
ByteToFile .responsebody, strFileName
End With
End Sub
Sub ByteToFile(arrByte, strFileName As String)
With CreateObject("Adodb.Stream")
.Type = 1 'adTypeBinary
.Open
.Write arrByte
.SaveToFile strFileName, 2 'adSaveCreateOverWrite
.Close
End With
End Sub
|
|