1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
| 'enregistrement de la FDM à envoyer par FTP
are = Left(Worksheets(1).Range("L2"), 3)
fdm = "C:\TEMP\" & Range("L2") & ".xls"
ThisWorkbook.SaveAs (fdm)
strPassword = "xxxx"
strUserName = "xxxxxxxxxxxxxx"
ftpServer = "o xxxxx.xxx.xxx.xxx.fr"
' creation du script FTP et enregistrement provisoire
script = Environ("TEMP") & "\script.ftp"
Open script For Output As #1
Print #1, ftpServer
Print #1, strUserName
Print #1, strPassword
Print #1, "cd FDM"
Print #1, "put " & fdm
Print #1, "cd FDM/FCMOCSV"
Print #1, "put " & stF
Print #1, "quit"
Close #1
Shell "ftp -n -s:" & Chr(34) & script & Chr(34) & Space(1) & ftpServer |
Partager