Hello,
Essaie ça
Sub Importer_Dn()
Set wb1 = ThisWorkbook
TheFile = Application.GetOpenFilename("Classeurs Excel(*.*),*.*")
Set wb2 = Workbooks.Open(TheFile)
For n = 1 To wb1.Sheets.Count
wb1.Sheets(n).Copy After:=wb2.Sheets(n)
wb1.Sheets(n).Range("A1:CZ6000").Copy
With wb2.Sheets(n).Range("A1:CZ6000")
.PasteSpecial (xlFormats)
.PasteSpecial (xlValues)
End With
Next
End Sub
Fait sur un coin de table, mais ça marche