run exiftool in a shell

[danielfcd]

Hello,
I try to use exiftool in a vba module using shell. No way to success !
If i use exiftool in command line mode, for example :
C:\Program Files (x86)\Geosetter\tools>exiftool.exe "F:\Images\2019\08\P1040103.jpg" > "F:\Images\exif.txt"
it works perfectly.
But if i put this command in a shell :

Code Select Expand

Shell "C:\Program files (x86)\Geosetter\tools\exiftool.exe & " -w " & Chr(34) & "F:\Images\exif.txt" & " " & Chr(34) & " " & Chr(34) & "F:\Images\2019\08\P1040103.jpg" & Chr(34)
it does not work, regardless chr(34) or not, regardless double quote or not.
I spent many hours changing the syntax without success.
The objective is obviously to get the exif data of an image in a file text.
Sorry, i'm not expert in shell and in english language !

In addition this a shell to start Geosetter which works well.

Code Select Expand


Private Sub GeoSetter_Click()
Dim cheminphoto As String

cheminphoto = disquePhotos & racinePhotos & "\" & photosSélectionnées(1).Chemin
Shell "C:\Program Files (x86)\GeoSetter\GeoSetter.exe" & " " & Chr(34) & cheminphoto & Chr(34)
Exit Sub

End Sub

Thank you
Regards

[Phil Harvey]

Did you check the programming section on the ExifTool home page to see if there is an example?

- Phil

[danielfcd]

I have a look to the programming section and find an example which can solve my problem; The exif data are stored into a data structure instead of a text file, but i can adapt my program.
I tried to modify the example to store the data into a file, but it does not work.
I will not know how to store in a file, but the important thing is to have a solution !
Thank you Phil and congratulations for this wonderful too exiftool;
regards
Daniel