1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33
|
' tout en haut, dans la partie générale
Option Explicit
Private Type SHITEMID
cb As Long
abID As Byte
End Type
Private Type ITEMIDLIST
mkid As SHITEMID
End Type
Private Declare Function SHGetSpecialFolderLocation Lib "shell32.dll" (ByVal hwndOwner As Long, ByVal nFolder As Long, pidl As ITEMIDLIST) As Long
Private Declare Function SHGetPathFromIDList Lib "shell32.dll" Alias "SHGetPathFromIDListA" (ByVal pidl As Long, ByVal pszPath As String) As Long
Private Sub Command1_Click()
Dim r As Long, chemin As String, toto As String, monfiltre As String, fichiers As String
Dim IDL As ITEMIDLIST
r = SHGetSpecialFolderLocation(100, 0, IDL)
toto = ""
If r = 0 Then
chemin = Space$(512)
r = SHGetPathFromIDList(ByVal IDL.mkid.cb, ByVal chemin)
toto = Left$(chemin, InStr(chemin, Chr$(0)) - 1)
End If
monfiltre = "*.XLS"
fichiers = Dir(toto & "\" & monfiltre)
Do While fichiers <> ""
MsgBox fichiers
fichiers = Dir
Loop
End Sub |
Partager