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

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



"EXCEL$B!!(BNEWS" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> 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
>
>

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/ind...7&#entry618967
and download the attachment there, plus the dll at:
http://members.cox.net/foxbat121/exifview.html

--
Cheers
macropod
[Microsoft MVP - Word]


"EXCEL$B!!(BNEWS" <(E-Mail Removed)> wrote in message news:%(E-Mail Removed)...
> 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
>
>

Thanks,it hleps


"Tim Williams" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>
>
>
> "EXCEL$B!!(BNEWS" <(E-Mail Removed)> wrote in message
> news:%(E-Mail Removed)...
>> 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
>>
>>
>
>

Thanks,it hleps
"macropod" <(E-Mail Removed)> wrote in message
news:esFh4$(E-Mail Removed)...
> 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/ind...7&#entry618967
> and download the attachment there, plus the dll at:
> http://members.cox.net/foxbat121/exifview.html
>
> --
> Cheers
> macropod
> [Microsoft MVP - Word]
>
>
> "EXCEL$B!!(BNEWS" <(E-Mail Removed)> wrote in message
> news:%(E-Mail Removed)...
>> 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
>>
>>
>