Dim App As Object
On Error Resume Next
Set App = GetObject(, "Excel.Application")
If Err <> 0 Then Set App = CreateObject("Excel.Application")
With App
.Workbooks.OpenText FileName:="ADRESSE" & fichier, DataType:=1, Semicolon:=True, local:=True
.Visible = True 'Or False
.ActiveSheet.Range("$A$1:$AD$20000").RemoveDuplicates Columns:=3, Header:=xlYes
.Workbooks("fichier").Close 0 'ou 0
.Quit
End With
Set App = Nothing