Sub Import_Stock_Anomalies()
Dim a As Variant, wkA As Workbook, act As Workbook
Application.ScreenUpdating = False
ChDrive "C:" ' Choix du lecteur
ChDir "C:\" 'Choix du répertoire
a = Application.GetOpenFilename("fichier excel (*.xlsm), *.xlsm", _
, "Sélection de vos fichiers excel")
If a = False Then Exit Sub
Set wkA = Workbooks.Open(a)
'classeur actuel
'Set act = ThisWorkbook
Sheets(1).Select 'Selection feuille active
Selection.AutoFilter Field:=10, Criteria1:="Créée"
wkA.Sheets(1).Cells.Copy ThisWorkbook.Sheets("Stock Anomalies").Range("A1")
End Sub