Option Explicit
'Déclaration des API Windows pour permettre la récupération du fichier sur le serveur FTP
Private Declare Function InternetCloseHandle Lib "wininet.dll" (ByVal hInet As Long) As Integer
Private Declare Function InternetConnect Lib "wininet.dll" Alias "InternetConnectA" _
(ByVal hInternetSession As Long, ByVal sServerName As String, ByVal nServerPort As Integer, _
ByVal sUserName As String, ByVal sPassword As String, ByVal lService As Long, _
ByVal lFlags As Long, ByVal lContext As Long) As Long
Private Declare Function InternetOpen Lib "wininet.dll" Alias "InternetOpenA" _
(ByVal sAgent As String, ByVal lAccessType As Long, ByVal sProxyName As String, _
ByVal sProxyBypass As String, ByVal lFlags As Long) As Long
Private Declare Function FtpSetCurrentDirectory Lib "wininet.dll" Alias _
"FtpSetCurrentDirectoryA" (ByVal hFtpSession As Long, _
ByVal lpszDirectory As String) As Boolean
Private Declare Function FtpGetFile Lib "wininet.dll" Alias "FtpGetFileA" _
(ByVal hConnect As Long, ByVal lpszRemoteFile As String, _
ByVal lpszNewFile As String, ByVal fFailIfExists As Long, _
ByVal dwFlagsAndAttributes As Long, ByVal dwFlags As Long, _
ByRef dwContext As Long) As Boolean
Private Declare Function FtpPutFile Lib "wininet.dll" Alias _
"FtpPutFileA" (ByVal hConnect As Long, ByVal lpszLocalFile As String, _
ByVal lpszNewRemoteFile As String, ByVal dwFlags As Long, _
ByVal dwContext As Long) As Boolean
Public Sub ImportFTP()
On Error GoTo Err_Sub
' Marco développé par : Shwin - http://www.developpez.net/forums/member.php?u=26564
' Source : http://access.developpez.com/sources/?page=Fichiers#EnvoiFTP
Dim HwndConnect As Long
Dim HwndOpen As Long, MyFile
' Lance l'ouverture du site ftp
HwndOpen = InternetOpen("ftp://nomsite", 0, vbNullString, vbNullString, 0)
'Connection au site ftp
HwndConnect = InternetConnect(HwndOpen, SiteFTP, [COLOR=green][B]21[/B][/COLOR], [COLOR=green][B]Login[/B][/COLOR], [COLOR=green][B]Mdp[/B][/COLOR], 1, 0, 0)
'positionnement du curseur dans le répertoire
FtpSetCurrentDirectory HwndConnect, "/travail"
'Téléchargement du fichier
Dim Rep,NomFic as string, VPathFileName as String
NomFic = "Monfic.xls"
VPathFileName = "C:\Temp\NouveauNom.xls"
Rep = FtpGetFile(HwndConnect, NomFic, VPathFileName, False, 0, &H0, 0)
' Vérifier que le fichier a bien été téléchargé
If Rep = False Then
InternetCloseHandle HwndConnect 'Ferme la connection
InternetCloseHandle HwndOpen 'Ferme internet
MsgBox "Impossible d'importer le fichier : " & NomFic & vbCrLf _
& "Arrêt de la macro !"
End
End If
' Ferme le handle de connection puis celui d'Internet
InternetCloseHandle HwndConnect
InternetCloseHandle HwndOpen
Exit Sub
Err_Sub:
MsgBox "Une erreur c'est produite, arrêt de la macro"
InternetCloseHandle HwndConnect 'Ferme la connection
InternetCloseHandle HwndOpen 'Ferme internet
FlgErr = True
End
End Sub
