I have a large number of JPEG files taken from various phones that have GPS latitude and longitude data. I can view this data by looking up the file properties (details) individually in windows explorer.

Is it possible to retrieve this GPS data in VBA? I would like to retrieve the latitude and longitude for each file into a spreadsheet.

I'm using Windows 7 and Excel 365.

I did see some old posts that seemed to relate but the links to solutions were no longer valid.


Thanks in advance.