Private Sub Ouvrfichier_Click()
'selectionner un repertoire contenant des *.xls
Dim objShell As Object, objFolder As Object
Dim SecuriteSlash As Integer
Dim Fichier As String, S As String, X As String, CheminTemp As String
Dim ProprietesImages As String
'necessite d'activer la reference Microsoft Scripting RunTime
Dim Fso As Scripting.FileSystemObject
Dim FileItem As Scripting.File
On Error Resume Next
Set objShell = CreateObject('Shell.Application') 'recuperer nom repertoire cible
Set objFolder = objShell.BrowseForFolder(&H0&, 'Choisir un répertoire', &H1&)
CheminTemp = Chemin
Chemin = objFolder.ParentFolder.ParseName(objFolder.Title).Path
If objFolder.Title = '' Then Chemin = ''
SecuriteSlash = InStr(objFolder.Title, ':')
If SecuriteSlash > 0 Then Chemin = Mid(objFolder.Title, SecuriteSlash - 1, 2) & ''
If Chemin = '' Then
Filesss = ThisWorkbook.Path
Chemin = CheminTemp
Exit Sub
End If
Fichier = Dir(Chemin & '\\*.xls') 'ciblage des *.xls dans ce repertoire
If Fichier = '' Then
Else
Filesss = Chemin
End If
End Sub