|
本帖最后由 andysky 于 2017-1-20 11:17 编辑
送给大家从网上下载文件的VBA代码 Private Declare Function URLDownloadToFile Lib "urlmon" Alias "URLDownloadToFileA" (ByVal pCaller As Long, ByVal szURL As String, ByVal szFileName As String, ByVal dwReserved As Long, ByVal lpfnCB As Long) As Long
Sub 从百度下载图片到C盘()
Dim xmlhttp, ayrHttpBody() As Byte
Set xmlhttp = CreateObject("microsoft.xmlhttp")
With xmlhttp
.Open "GET", "https://ss1.baidu.com/9vo3dSag_xI4khGko9WTAnF6hhy/image/h%3D300/sign=8c56d4a6d8c8a786a12a4c0e5708c9c7/5bafa40f4bfbfbed022d422371f0f736afc31f71.jpg", False '设定访问下载文件
.send
End With
ayrHttpBody() = xmlhttp.Responsebody
Open "c:\123.jpg" For Binary As #1
Put #1, , ayrHttpBody()
Close #1
End Sub
以上代码的功能是从百度下载图片到C盘中,名为123.jpg
|
评分
-
1
查看全部评分
-
|