Sub Test_Aloha_II()
Dim FSO As Object, WorkBk As Workbook, wDs As Worksheet, ws As Worksheet, t
Dim oFile
Dim oFolder
Set FSO = CreateObject("Scripting.FileSystemObject")
Set wDs = ThisWorkbook.Sheets("Database")
Dim sFolderName$, oFldialog As FileDialog
Set oFldialog = Application.FileDialog(msoFileDialogFolderPicker)
With oFldialog
If .Show = -1 Then
.Title = "Sélectionner le dossier source"
.AllowMultiSelect = False
sFolderName = .SelectedItems(1)
Else
Exit Sub
End If
End With
Application.ScreenUpdating = False
Set oFolder = FSO.GetFolder(sFolderName)
For Each oFile In oFolder.Files
If oFile.Name Like "*.xl*" Then
Set WorkBk = Workbooks.Open(oFile)
For Each ws In WorkBk.Worksheets
t = ws.Range("A1:A10").Value
wDs.Cells(Rows.Count, 1).End(xlUp)(2).Resize(, UBound(t)) = Application.Transpose(t)
Next
Erase t
WorkBk.Close False
End If
Next
End Sub