'##### FLoadNomDuREPwin le plus simple méthode Windows explorateur #####
Public Function FLoadNomDuREPwin() As String
With Application.FileDialog(msoFileDialogFolderPicker)
.ButtonName = "OK"
.InitialFileName = ThisWorkbook.Path & "\"
.Title = "Sélectionnez un dossier"
.Show
If .SelectedItems.Count > 0 Then FLoadNomDuREPwin = .SelectedItems(1) & "\" Else FLoadNomDuREPwin = ""
'ou direct
'If .Show = -1 Then FLoadNomDuRepwin = .SelectedItems(1)& "\" Else FLoadNomDuRepwin = ""
End With
End Function
'##### select la petite boite ouvrir dossier (sans fonction ni référence) #####
'(&H0&, "Sélectionnez un dossier", &H201&, "C:\") (&H1&=avec "créer un nouveau dossier") (&H201& sans)
'Set ObjFolder = CreateObject("Shell.Application").BrowseForFolder(&H0&, Message$, &H201&, RepParDefaut$)
Public Function FLoadNomDuREP2() As String
Dim ObjFolder As Object, Rep As String
Set ObjFolder = CreateObject("Shell.Application").BrowseForFolder(0, "Sélectionnez un dossier", &H201&, "")
If Not ObjFolder Is Nothing Then
Rep = ObjFolder.Items.Item.Path
If Right(Rep, 1) <> "\" Then Rep = Rep & "\"
End If
FLoadNomDuREP2 = Rep
Set ObjFolder = Nothing
End Function