엑셀 매크로 VBA 12. 나의 함수 : 웹파일 다운로드 소스

엑셀 매크로 VBA 12. 나의 함수 : 웹파일 다운로드 소스

웹다운로드 소스

Option Explicit

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

 

Private Const ERROR_SUCCESS As Long = 0

Private Const BINDF_GETNEWESTVERSION As Long = &H10

Private Const INTERNET_FLAG_RELOAD As Long = &H80000000

Private Function DownloadFileFromWeb(sSourceUrl As String, sLocalFile As String) As Boolean

    DownloadFileFromWeb = URLDownloadToFile(0&, sSourceUrl, sLocalFile, BINDF_GETNEWESTVERSION, 0&) = ERROR_SUCCESS

End Function

.