Getting Photo Create Date

Question

Is it possible to have excel pull the "Photo Create Date" from a JPG file.  I have the list of file names and I want to put in the next column the photo create date taken from the photos extended data.

Thanks

Answer 1

Am 27.10.2010 00:34, schrieb Paul AZ:

Is it possible to have excel pull the "Photo Create Date" from a JPG file.

I found a EXIF-Reader for VB which works also in VBA:

http://sourceforge.net/projects/exifclass/

Sub Test()

  Dim EX As New ExifReader

  EX.Load "C:\temp\test.jpg"

  Debug.Print EX.Tag(DateTimeOriginal)

End Sub

Andreas.

Answer 2

photo create date taken from the photos extended data.

Have a look at this side:

http://www.vbaccelerator.com/home/VB/Code/vbMedia/Using_GDI_Plus/Reading_EXIF_and_Other_Image_Properties/article.asp

Andreas.