Retrieve DATE PICTURE TAKEN property from a file using VBA in Excel.

I want to rename all photos in a folder using the date/time the picture was taken. currently my code is:

Please Login or Register  to view this content.

This works perfectly if the file hasn't been edited before running the macro. BUT, if a photo has been resized, the last modified date/time stamp is updated. I want to access the "DATE TAKEN" field which is visible in windows rather than the last modified property.

Any suggestions?

Thanks David. With your help I've managed to do it. Superb.

Originally Posted by Tinbendr

You'll have to use Shell to get the extended proerties.

See also this help article.

Please Login or Register  to view this content.

Hi there
I know the thread it's a bit old but I'm having issues with GetDetailsOf thingy
For me property 25 returns nothing, and property 12 holds the value. However it returns ?4/?17/?2015 ??11:48 AM, so needless to say, it's not recognized as a date if I try to use it further down the line.
I'm using Office 2010, and the image comes from an Canon 650D, if this info holds any value.
Thank you very much.
Regards
Razvan

Mine also returns ?4/?17/?2015 ??11:48 AM

How do I get rid of this feature. I have tried

Please Login or Register  to view this content.

but it does not work

I have also tried this recently and no luck at all.

Please Login or Register  to view this content.