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
| DefBool Y
'Cette instruction doit se trouver sur la première ligne du module
'Avant toute autre déclaration ,Sub ou Function
Function testo()
Dim Y, Y1, Y2, Y3, Y4, Y5, Y6, i% ' % = As integer
Dim tab_entete() As Integer
Dim Nb_Feuil
Dim Nb_Champ
Dim Ligne_Depart
Dim Num_Col
affiche_tous
For i = 1 To Worksheets.Count
With Worksheets(i)
Y1 = Left(.Name, 8) = "Synthese"
Y2 = Left(.Name, 1) = "_"
Y3 = Left(.Name, 6) = "Modele"
Y4 = Left(.Name, 3) = "CAL"
Y5 = Left(.Name, 9) = "Bienvenue"
Y6 = Left(.Name, 3) = "PIP"
Y = Y1 Or Y2 Or Y3 Or Y4 Or Y5
If Not Y Then
If Y <> Y6 Then
With Worksheets(i)
Col_rapport = 1
i = 0
i = i + 1
ligne_debut = Range("DTE_CARTO").Row + 1
ligne_fin = Range("STOP").Row - 1
For cpt = ligne_debut To ligne_fin
Rapport_lib = Cells(cpt, Col_rapport)
'Alimentation du tableau
cpt0 = 0
tab_entete(cpt0, cpt_tab) = Dte_Carto
cpt_tab = cpt_tab + 1
ReDim Preserve tab_entete(Nb_Champ, cpt_tab)
Next
End With
End If
End If
GoTo continue
Y = Y6
If Y = Y6 Then
With Worksheets(i)
Col_rapport = 3
i = 0
i = i + 1
ligne_debut = Range("Etat_lib").Row + 1
ligne_fin = Range("STOP").Row - 1
For cpt = ligne_debut To ligne_fin
Etat_lib = Cells(cpt, Col_rapport)
'Alimentation du tableau
cpt0 = 0
tab_entete(cpt0, cpt_tab) = Etat_lib
cpt_tab = cpt_tab + 1
ReDim Preserve tab_entete(Nb_Champ, cpt_tab)
Next
End With
End If
End With
Next
continue: SousRepRepActuel
End Function
Function maj_liens()
'DocScan (toto)
End Function
Function SousRepRepActuel()
Dim tab_data(3, 10000)
Racine = ActiveWorkbook.Path ' Répertoire courant
Set fs = CreateObject("Scripting.FileSystemObject")
Set Dossier = fs.GetFolder(Racine)
[A1].Select
i = 0
For Each d In Dossier.subfolders
For Each f In Dossier.Files
tab_data(0, i) = Left(f.Name, InStr(f.Name, ".") - 1)
tab_data(1, i) = f.Path & "\"
tab_data(2, i) = f.Name
i = i + 1
Next
Set Dossier = fs.GetFolder(Dossier.subfolders)
Next
End Function |
Partager