date of JPG photo file which is taken

E

EXCEL NEWS

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
 
T

Tim Williams

Go here:
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
 
E

EXCEL NEWS

Thanks,it hleps


Tim Williams said:
Go here:
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
 
E

EXCEL NEWS

Thanks,it hleps
macropod said:
Hi,

To see how you can extract the EXIF data for all jpegs in a foilder to an
Excel file, go to:
http://lounge.windowssecrets.com/index.php?showtopic=618967&st=0&p=618967&#entry618967
and download the attachment there, plus the dll at:
http://members.cox.net/foxbat121/exifview.html

--
Cheers
macropod
[Microsoft MVP - Word]


EXCEL NEWS said:
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top