Sub Test_OK()
'ici remplacer par le chemin du dossier puis par le nom de l'image
'ne pas oublier le \ de fin et l'extension de l'image
Lire_IMG "C:\Users\STAPLE\Pictures\NICEPHORE\", "CIMG0616.JPG"
End Sub
Private Sub Lire_IMG(Chemin$, NomIMG$)
Dim t, tt
t = Split(Lire_Proprietes_IMG(Chemin & NomIMG, 0), ";")
tt = Split(Lire_Proprietes_IMG(Chemin & NomIMG, 39), ";")
Range("A1").Resize(UBound(t)) = Application.Transpose(t)
Range("B1").Resize(UBound(tt)) = Application.Transpose(tt)
End Sub
Function Lire_Proprietes_IMG(strFilewFullPath, iDoHeaders As Integer)
'fonction originale:GetFileProperties2
'par Shasur M
Const arrSize = 39
Dim strFile$, strFileName, strPath$, sTemp As Variant, I%, fsize%
Dim idate As Date, idimension$, Camera$, objShell As Object
Dim arrHeaders(arrSize)
Dim objFolder As Object, oFile As Object, arTemp
Set objShell = CreateObject("Shell.Application") '=====
strFile = Dir(strFilewFullPath)
strPath = Left(strFilewFullPath, InStrRev(strFilewFullPath, "\") - 1)
arTemp = Split(strFilewFullPath, "\")
strFileName = arTemp(UBound(arTemp))
Set objFolder = objShell.Namespace(strPath & "\")
For I = 0 To arrSize
arrHeaders(I) = objFolder.GetDetailsOf(objFolder.Items, I)
Next I
Lire_Proprietes_IMG = ""
Set oFile = objFolder.ParseName(strFileName)
For I = 0 To arrSize
sTemp = arrHeaders(I)
If iDoHeaders = 0 Then
If IsNull(sTemp) Or sTemp = "" Then sTemp = "Manquant"
Lire_Proprietes_IMG = Lire_Proprietes_IMG & sTemp & ";"
Else
sTemp = objFolder.GetDetailsOf(oFile, I)
If IsNull(sTemp) Then sTemp = "Manquant"
Lire_Proprietes_IMG = Lire_Proprietes_IMG & sTemp & ";"
End If
Next I
End Function