Dear experts,
I have multiple images stored in a folder, and their names are listed in column A of my Excel sheet. I would like to add geo-location data to these images using Excel VBA.
Dear experts,
I have multiple images stored in a folder, and their names are listed in column A of my Excel sheet. I would like to add geo-location data to these images using Excel VBA.
Try:ArtikPlease Login or Register to view this content.
Thanks @Artik
I think i made some confusion, i want excel latitude longitude to image file.
hi,
In the example below, select the image and then the macro inserts the geolocation and date that are embedded in the image, in the bottom left corner of the image, and then saves the image to the desktop with the same name.
putlatitudeandlongitudeinimage.xlsm
The GPS datas are found in the EXIF properties of an image file and can be read if exists by WIA (Windows Image Acquisition)
If not exists, can be added by third party programs such as "ExifTool" by Phil Harvey (https://exiftool.org/)
But, if you like to have a simple solution by VBA using the WIA object; the following simple code will add the GPS data in the "Comments" section of the JPG file as seen in the picture below.
The code will create a new file in the same directory with a file name starting with "New_***"
Please Login or Register to view this content.
Last edited by Haluk; 03-29-2024 at 03:32 AM.
I worked on the subject and finally managed to add "Longitude" data (decimal 24.858) to the image file's GPS section as seen in the picture below, by the following code.
Please Login or Register to view this content.
Latitude and altitude datas can also be added by using appropriate values and similar methods.
@ rajatds31,
Seems you have lost your interest on the subject
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks