Go he
http://sourceforge.net/projects/exifclass/
Download the (zipped) source code - extract the "cls" file and import to
your VBA project (it's for VB6 but seems to work fine in Excel VBA).
Example usage:
Sub Tester()
Dim exif As New ExifReader
exif.Load "D:\Pics\2009\CIMG1730.JPG"
Debug.Print exif.Tag(DateTimeOriginal)
End Sub
Tim
"EXCEL NEWS" wrote in message
...
hi,
i am using a lot of photos taken at a construction cite,and i have to
write the date of JPG file which is taken
to excel sheet.
how can i get the date VBA property of which is taken at cite.
I mean the date of taking photo
thanks