Sub import()
Dim Fichier As String
Application.ScreenUpdating = False
Application.DisplayAlerts = False
Fichier = "C:\Documents and Settings\MON ORDI\Bureau\EX.xls"
Workbooks.Open Fichier
Fichier = ActiveWorkbook.Name
Workbooks(Fichier).Sheets(1).Copy before:=Workbooks("EX2.xls").Sheets(1)
If Err.Number = 0 Then
ActiveSheet.Name = "Feuille-importée_" & ActiveWorkbook.Worksheets.Count
Else
ActiveSheet.Name = "Feuille-importée"
End If
Workbooks(Fichier).Close
End Sub