Extract image metadata with VBA

[Jet Fusion]

Hi all

I know there is a post about 14 years ago but It does not work. Does anyone know of a vba code that can extract the metadata of an image. I have to get the gps location longitude and latitude and reference it to a drawing but there is over 5000 pics and thought I could get vba to list them in excel then run a script to load it to the drawing. The details I need is similar to the details you get from right clicking on a image and properties then details tab.

Thanks
Jet

 

[vletm]

Did You 'Googled' and test eg below links?

VBA to get name, date and GPS data from pictures in a folder

I have looked and can't fine code to do this, I have a folder with pictures in it and I would like to put the names of each picture in the folder in column A, date taken in column B and if the pictures have GPS data for them put the latitude in column C and the longitude in column D, can this...

www.mrexcel.com

Getting Image EXIF Information Through Access VBA

Sorry, having an awful time with the images here. Why won't this site let me delete images and replace them? Hopefully you can figure out what images are what. Hi folks, I've been searching for a few days on this and the most promising approach, using WIA (Windows Image Acquisition) seems...

www.accessforums.net

 

[Jet Fusion]

Hi Vletm

I've tried most of them but always seem to get some error not sure if it's because I am working on win11 and 64 alot of the codes might be for 32.

I tried the Exiftool where you drag and drop that works but for some reason when I tried to export to csv I get the error C:\ExifTool\exiftool_files\perl5*.dll error but the files are there in the folder as they were extracted.
When I use cmd to run Exiftool i get that same error and doesn't run. I'm not sure if I went thro the whole process correctly but by what I read you had to unzip and rename the file without the (k) which I did.

So i'm not sure. So near but yet so far

Did You 'Googled' and test eg below links?

VBA to get name, date and GPS data from pictures in a folder

I have looked and can't fine code to do this, I have a folder with pictures in it and I would like to put the names of each picture in the folder in column A, date taken in column B and if the pictures have GPS data for them put the latitude in column C and the longitude in column D, can this...

www.mrexcel.com

Getting Image EXIF Information Through Access VBA

Sorry, having an awful time with the images here. Why won't this site let me delete images and replace them? Hopefully you can figure out what images are what. Hi folks, I've been searching for a few days on this and the most promising approach, using WIA (Windows Image Acquisition) seems...

www.accessforums.net