Bonjour Steelson,
Je viens de tester, mais j'ai une erreur à
monFichier = Dir(chemin & "*.xlsm")
"Nom ou numéro de fichier incorrect"
Option Explicit
Dim wbk1 As Workbook, wbk2 As Workbook
Dim ws1 As Worksheet, ws2 As Worksheet
Dim rng1 As Range, rng2 As Range
Dim chemin$, monFichier$, onglet$
Sub collecter()
' à modifier ...
chemin = ThisWorkbook.Path & "\E:\TEST-ARCHIVAGE\"
onglet = "Sauvegarde"
Set wbk1 = ThisWorkbook
Set ws1 = wbk1.Sheets(onglet)
ws1.Cells(1).CurrentRegion.Offset(1, 0).ClearContents
monFichier = Dir(chemin & "*.xlsm")
Do While monFichier <> ""
If Not monFichier Like "*.xlsm" Then
Set wbk2 = Workbooks.Open(chemin & monFichier)
Set ws2 = wbk2.Sheets(onglet)
Set rng2 = ws2.Cells(1).CurrentRegion
rng2.Offset(1).Resize(rng2.Rows.Count - 1, rng2.Columns.Count).Copy
Set rng1 = ws1.Cells(Rows.Count, 1).End(xlUp).Offset(1, 0)
rng1.PasteSpecial Paste:=xlPasteValuesAndNumberFormats
Application.CutCopyMode = False
wbk2.Close False
End If
monFichier = Dir
Loop
ws1.Cells(Rows.Count, 1).End(xlUp).Offset(1, 0).Select
End Sub