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 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100
|
Public Sub btnDPT_Click()
'Repère les 3 valeurs de la ListBox
DPT = DPT_number_clientLB.List(DPT_number_clientLB.ListIndex, 0)
nbdossier = DPT_number_clientLB.List(DPT_number_clientLB.ListIndex, 1)
client = DPT_number_clientLB.List(DPT_number_clientLB.ListIndex, 2)
DestinationHG = "C:\Users\alain\Desktop\DATA BASE\HG\"
Destination = "C:\Users\alain\Desktop\DATA BASE\DATA\"
DestinationNOTFOUND = "C:\Users\alain\Desktop\DATA BASE\NOT FOUND\"
NomFich = Dir(DestinationHG & "*.pdf")
Dim tbl()
Dim Path As String, Fullname As String
Dim Elem As Integer, msg As String
' Affectation
Path = ThisWorkbook.Path & "Destination"
Fullname = Path & "*.pdf"
tbl = FileList(Fullname)
'
For Elem = 0 To UBound(tbl)
prefixe2 = Left(NomFich, 2)
prefixe3 = Left(NomFich, 3)
prefixe4 = Left(NomFich, 4)
chemin = "X:\1-DOSSIERS CLIENTS\" & DPT & "\" & client & "-" & DPT & "-" & nbdossier & "\"
If prefixe2 = "DP" Then
chemin = chemin & "A-DP-" & client & "-" & DPT & "-" & nbdossier & "-Demarches prealables\"
ElseIf prefixe2 = "DV" Then
If prefixe3 = "DV0" Then
chemin = chemin & "B-DV-" & client & "-" & DPT & "-" & nbdossier & "-Developpement\" & "DV0-" & client & "-" & DPT & "-" & nbdossier & "-Courriers divers\"
ElseIf prefixe4 = "DV1A" Then
chemin = chemin & "B-DV-" & client & "-" & DPT & "-" & nbdossier & "-Developpement\" & "DV1A-" & client & "-" & DPT & "-" & nbdossier & "-Arpentage\"
ElseIf prefixe4 = "DV1-" Then
chemin = chemin & "B-DV-" & client & "-" & DPT & "-" & nbdossier & "-Developpement\" & "DV1-" & client & "-" & DPT & "-" & nbdossier & "-Demande de permis de construire\"
ElseIf prefixe3 = "DV2" Then
chemin = chemin & "B-DV-" & client & "-" & DPT & "-" & nbdossier & "-Developpement\" & "DV2-" & client & "-" & DPT & "-" & nbdossier & "-Demande de raccordement\"
ElseIf prefixe4 = "DV3" Then
chemin = chemin & "B-DV-" & client & "-" & DPT & "-" & nbdossier & "-Developpement\" & "DV3-" & client & "-" & DPT & "-" & nbdossier & "-Bail\"
Else
chemin = chemin & "B-DV-" & client & "-" & DPT & "-" & nbdossier & "-Developpement\"
End If
Else
If prefixe4 = "CO00" Then
chemin = chemin & "C-CO-" & client & "-" & DPT & "-" & nbdossier & "-Construction\" & "CO00-" & client & "-" & DPT & "-" & nbdossier & "-Photos\"
ElseIf prefixe4 = "CO0-" Then
chemin = chemin & "C-CO-" & client & "-" & DPT & "-" & nbdossier & "-Construction\" & "CO0-" & client & "-" & DPT & "-" & nbdossier & "-Courriers divers\"
ElseIf prefixe3 = "CO1" Then
chemin = chemin & "C-CO-" & client & "-" & DPT & "-" & nbdossier & "-Construction\" & "CO1-" & client & "-" & DPT & "-" & nbdossier & "-Devis\"
ElseIf prefixe3 = "CO2" Then
chemin = chemin & "C-CO-" & client & "-" & DPT & "-" & nbdossier & "-Construction\" & "CO2-" & client & "-" & DPT & "-" & nbdossier & "-Etat des lieux fiche technique\"
ElseIf prefixe3 = "CO3" Then
chemin = chemin & "C-CO-" & client & "-" & DPT & "-" & nbdossier & "-Construction\" & "CO3-" & client & "-" & DPT & "-" & nbdossier & "-Branchement\"
ElseIf prefixe3 = "CO4" Then
chemin = chemin & "C-CO-" & client & "-" & DPT & "-" & nbdossier & "-Construction\" & "CO4-" & client & "-" & DPT & "-" & nbdossier & "-Echanges relatifs aux travaux avec ENEDIS\"
ElseIf prefixe3 = "CO5" Then
chemin = chemin & "C-CO-" & client & "-" & DPT & "-" & nbdossier & "-Construction\" & "CO5-" & client & "-" & DPT & "-" & nbdossier & "-Etude charpente\"
ElseIf prefixe3 = "CO6" Then
chemin = chemin & "C-CO-" & client & "-" & DPT & "-" & nbdossier & "-Construction\" & "CO6-" & client & "-" & DPT & "-" & nbdossier & "-Plans\"
ElseIf prefixe3 = "CO7" Then
chemin = chemin & "C-CO-" & client & "-" & DPT & "-" & nbdossier & "-Construction\" & "CO7-" & client & "-" & DPT & "-" & nbdossier & "-Devis signes\"
Else
chemin = chemin & "C-CO-" & client & "-" & DPT & "-" & nbdossier & "-Construction\"
End If
End If
NomFich2 = Mid(NomFich, InStrRev(NomFich, "-") + 1)
NomFich3 = Dir(chemin & "*-" & NomFich2)
If Len(NomFich3) > 0 Then
FileCopy chemin & NomFich3, Destination & NomFich3
Else
'fichier = prefixe3 & "-" & client & "-" & DPT & "-" & nbdossier & "-" & NomFich2
MsgBox ("Le fichier " & NomFich2 & " n'existe pas")
FileCopy DestinationHG & NomFich, DestinationNOTFOUND & NomFich
End If
Next |
Partager