1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48
| Sub SaveRIP()
Dim test, fdmca, script As String
'mise à jour automatique de la date lors de l'enregistrement
Range("S4").Value = Now()
On Error Resume Next
If Dir("C:\TEMP\", vbDirectory) <> "" Then
'enregistrement de la FDM à envoyer par FTP
are = Left(Worksheets(1).Range("L2"), 3)
fdm = "C:\TEMP\" & Range("L2") & ".xls"
ThisWorkbook.SaveAs (fdm)
' creation du script FTP et enregistrement provisoire
script = "C:\TEMP\script.ftp"
Open script For Output As #1
Print #1, "prompt"
Print #1, "0.199.0.0.0."
Print #1, "Adm.."
Print #1, "tartampion"
Print #1, "cd FDM"
Print #1, "put " & fdm
Print #1, "quit"
Close #1
Shell ("command.com /c ftp.exe -s:C:\TEMP\script.ftp")
Else
'enregistrement de la FDM à envoyer par FTP
are = Left(Worksheets(1).Range("L2"), 3)
fdm = "C:\Users\Public\FCMOarch\" & Range("L2") & ".xls"
ThisWorkbook.SaveAs (fdm)
' creation du script FTP et enregistrement provisoire
script = "C:\Users\Public\script.ftp"
Open script For Output As #1
Print #1, "prompt"
Print #1, "0.199.0.0.0."
Print #1, "Adm.."
Print #1, "tartampion"
Print #1, "cd FDM"
Print #1, "put " & fdm
Print #1, "quit"
Close #1
Shell ("command.com /c ftp.exe -s:C:\Users\Public\script.ftp")
End If
ThisWorkbook.Saved = True
Application.Quit
End Sub |