第一种方法:后台下载
Private Declare Function URLDownloadToFile Lib "urlmon.dll" Alias "URLDownloadToFileA" (ByVal pCaller As Long, ByVal szURL As String, ByVal szFileName As String, ByVal dwReserved As Long, ByVal lpfnCB As Long) As Long
Private Sub Command1_Click()
URLDownloadToFile 0, "http://192.168.1.101/hbwl.rar", "c:\hbwl.rar", 0, 0
End Sub
第二种方法:文件另存为
Private Declare Function DoFileDownload Lib "shdocvw.dll" (ByVal lpszFile As String) As Long
Private Sub Command1_Click()
Dim gourl As String
gourl = StrConv("http://192.168.1.101/hbwl.rar", vbUnicode)
Call DoFileDownload(gourl)
End Sub
本文介绍两种使用VBA从网络下载文件的方法:一是通过调用URLDownloadToFile函数进行后台下载;二是利用DoFileDownload函数实现文件另存为的功能。这两种方法均可帮助用户在VBA环境中便捷地获取网络资源。
1106

被折叠的 条评论
为什么被折叠?



