'Source AllAPI
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
Public Function DownloadFile(ByVal URL As String, ByVal LocalFilename As String) As Boolean
Dim lngRetVal As Long
lngRetVal = URLDownloadToFile(0, URL, LocalFilename, 0, 0)
If lngRetVal = 0 Then DownloadFile = True
End Function
Sub ImportImage()
For i = 1 To 10 'URL images en A1:A10
chemin = Cells(i, 1)
nom = Mid(chemin, InStrRev(chemin, "/") + 1, Len(chemin))
DownloadFile chemin, "x:\xxx\xxx\" & nom 'renseigner répertoire de destination
Next
End Sub