Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Exif Information
Further to my earlier post …
A friend and I discussed the problem of sorting digital images on a PC in true chronological order, which a real pain when you have more than one digital camera. Windows will use the Date Created or Date Modified, though XP allows for a special selection called Date Picture Taken (if available). This is a little awkward to get at, and some applications do not use it (ie, a 3rd party application, like PolyView's Thumbnails which default to the Windows standard sort-by-Name, I believe ...). The image Exif DateTime gives the true creation time, and ensures that images can be sorted in "true" chronological order (as determined by the cameras' internal clocks). This problem was the catalyst for developing an Excel spreadsheet solution. It is not meant to be all-singing, all-dancing ... it's just a pleasant way to solve the above issue! The key to the whole exercise is a quick & reliable self-contained VBA method to extract the Exif DateTime, and then methods to sort, rename & copy easily follow ... If anyone is interested, let me know ... Mark |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot table cutting information of a part of the information | Excel Discussion (Misc queries) | |||
Help!! using sheet 1 information to change information on sheet 2 | Excel Worksheet Functions | |||
Information from one cell pulls information from another cell | Excel Programming | |||
EXIF information | Excel Programming | |||
EXIF information | Excel Programming |