Sub coller()
Dim Repertoire As String, Classeur As String
Repertoire = "d:\mes documents\test\"
Classeur = "bdd.xlsx"
Workbooks.Open Repertoire & Classeur
Sheets("Feuil1").Rows("2:2").Insert
ThisWorkbook.ActiveSheet.Rows(2).Copy ActiveWorkbook.Sheets("Feuil1").[a2]
ActiveWorkbook.Close True
End Sub