|
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
Function DownPicture(nUrl As String, Savepath)
Dim localFilename As String, lngRetVal As Long
localFilename = Savepath
lngRetVal = URLDownloadToFile(0, nUrl, localFilename, 0, 0)
If lngRetVal = 0 Then
MsgBox "OK"
Else
MsgBox "NG"
End If
End Function
Sub aaa()
MainUrf$ = "http://basic.10jqka.com.cn/api/stock/export.php?export=main&type=year&code=300223"
Savepath = "C:\main.xls"
Call DownPicture(MainUrf, Savepath)
End Sub
单独用 http://basic.10jqka.com.cn/api/s ... ear&code=300223
浏览器可以下载
大神帮忙看看
|
|