Sub choix_fichiers()
Dim Filename As String
Dim chemin As String
Dim fichier As String
With Application.FileDialog(msoFileDialogFilePicker)
.Show
On Error Resume Next
Filename = .SelectedItems.Item(1)
chemin = Left(Filename, InStrRev(Filename, "\", -1, vbTextCompare) - 1)
fichier = Mid(Filename, InStrRev(Filename, "\") + 1)
End With
If chemin <> "" Then Range("Chemin_du_fichier").Value = chemin
If chemin <> "" Then Range("Nom_du_fichier").Value = fichier
End Sub