Sub FCMLE()
Dim Source As Workbook, Cible As Workbook, DLC As Long, DLS As Long, FC As Worksheet
Set Cible = ThisWorkbook
Set FC = Cible.Worksheets("Fichier de base")
DLC = FC.Range("A" & Rows.Count).End(xlUp).Row
FC.Range("A2:H" & DLC).ClearContents
FC.Range("J2:N" & DLC).ClearContents
With Application.FileDialog(msoFileDialogFilePicker)
.AllowMultiSelect = False 'n'autorise pas choix multiple
If .Show = -1 Then ' si fichier sélectionné
Set Source = Workbooks.Open(.SelectedItems(1))
With Source.ActiveSheet
DLS = .Range("A" & Rows.Count).End(xlUp).Row
.Range("A2:H" & DLS).Copy FC.Range("A2")
.Range("I2:M" & DLS).Copy FC.Range("J2")
End With
Source.Close
Else
MsgBox "Aucun fichier sélectionné"
Exit Sub
End If
End With
End Sub