Les macros corrigées (attention ces macros ne tiennent pas compte de ton chemin de fichier puisque je n'ai pas ton ChDir
Option Explicit
Dim LR As ListRow, TData As ListObject
Sub extraction()
Dim FileS$
Set TData = Range("TData").ListObject
Application.ScreenUpdating = False
'ChDir "N:\chemin du dossier"
FileS = Application.GetOpenFilename("Tous les fichiers (*.*),*.*") 'c'est ici que le choix du fichier se faire
Workbooks.Open FileS, UpdateLinks:=False
ActiveWorkbook.Sheets("0 Page de garde").Activate
ReadFiche
End Sub
Sub ReadFiche()
Dim a, b(26)
[B5:K75].MergeCells = False
a = [B5:K75].Value
b(0) = a(5, 9)
b(1) = a(3, 1)
b(2) = a(4, 1)
b(3) = a(3, 9)
b(4) = a(4, 9)
b(5) = a(6, 1)
b(6) = a(7, 1)
b(7) = a(9, 1)
b(8) = a(9, 2)
b(9) = a(9, 4)
b(10) = a(19, 1)
b(11) = a(20, 1)
b(12) = a(21, 1)
b(13) = ""
b(14) = a(23, 1)
b(15) = a(23, 8)
b(16) = a(25, 1)
b(17) = a(26, 1)
b(18) = ""
b(19) = ""
b(20) = a(28, 1)
b(21) = a(29, 1)
b(22) = a(30, 1)
b(23) = ""
b(24) = ""
b(25) = ""
b(26) = ""
ActiveWorkbook.Close SaveChanges:=False
On Error Resume Next
Set LR = TData.DataBodyRange.Delete
Set LR = TData.ListRows.Add
LR.Range.Value = b
End Sub
A+