I am trying to combine image files taken by 4 different cameras by create
datetime. The camera times were not synced and have different date times for
the same period. I want to import the Filename and Date time Picture Taken
information into an excel file so that I can adjust the date time information
and sync the data. Any thoughts??

Jim Cone has a SUPER free Add-in called "ListFiles" that should do the job
nicely for you........I wouldn't be without it. It's available at

http://www.realezsites.com/bus/primitivesoftware/

Vaya con Dios,
Chuck, CABGx3




"John VanNierop" wrote:

I am trying to combine image files taken by 4 different cameras by create
datetime. The camera times were not synced and have different date times for
the same period. I want to import the Filename and Date time Picture Taken
information into an excel file so that I can adjust the date time information
and sync the data. Any thoughts??

John

Several methods to accomplish this.......I like Tushar's best if importing to
Excel.

To add a "Print Directory" feature to Explorer, go to
this KB Article.

http://support.microsoft.com/default...EN-US;q272623&

Or you can download Printfolder 1.2 from.....

http://no-nonsense-software.com/freeware/

I use PF 1.2 and find it to be more than adequate with custom
features.

OR Go to DOS(Command) prompt and directory.
Type DIR MYFILES.TXT

All the above create a *.TXT file which can be opened in Notepad or
Excel.

One more method if you want to by-pass the *.TXT file and pull
directly to Excel is to use Tushar Mehta's Excel Add-in. This allows filtering
and sorting once you have the data in Excel.

http://www.tushar-mehta.com/ scroll down to Add-insDirectory
Listing.

Download the ZIP file and un-zip to your Office\Library folder.


Gord Dibben MS Excel MVP

On Tue, 3 Oct 2006 09:11:02 -0700, John VanNierop <John
wrote:

I am trying to combine image files taken by 4 different cameras by create
datetime. The camera times were not synced and have different date times for
the same period. I want to import the Filename and Date time Picture Taken
information into an excel file so that I can adjust the date time information
and sync the data. Any thoughts??

Gord Dibben MS Excel MVP

The Print Directory failed to print the picture taken date time. I printed
the date the files were loaded into the directory. Will try the excel import
next.

"Gord Dibben" wrote:

John

Several methods to accomplish this.......I like Tushar's best if importing to
Excel.

To add a "Print Directory" feature to Explorer, go to
this KB Article.

http://support.microsoft.com/default...EN-US;q272623&

Or you can download Printfolder 1.2 from.....

http://no-nonsense-software.com/freeware/

I use PF 1.2 and find it to be more than adequate with custom
features.

OR Go to DOS(Command) prompt and directory.
Type DIR MYFILES.TXT

All the above create a *.TXT file which can be opened in Notepad or
Excel.

One more method if you want to by-pass the *.TXT file and pull
directly to Excel is to use Tushar Mehta's Excel Add-in. This allows filtering
and sorting once you have the data in Excel.

http://www.tushar-mehta.com/ scroll down to Add-insDirectory
Listing.

Download the ZIP file and un-zip to your Office\Library folder.


Gord Dibben MS Excel MVP

On Tue, 3 Oct 2006 09:11:02 -0700, John VanNierop <John
wrote:

I am trying to combine image files taken by 4 different cameras by create
datetime. The camera times were not synced and have different date times for
the same period. I want to import the Filename and Date time Picture Taken
information into an excel file so that I can adjust the date time information
and sync the data. Any thoughts??

Gord Dibben MS Excel MVP

The excel add-in seemed to work the best thus far. As long as the Date
Picture Taken is the same as the last the Last Update Date this will work
fine. It would be much better if it read the exif data of the picture file.
Going both ways would even be better,

Thank You for you time and help.

"John VanNierop" wrote:

The Print Directory failed to print the picture taken date time. I printed
the date the files were loaded into the directory. Will try the excel import
next.

"Gord Dibben" wrote:

John

Several methods to accomplish this.......I like Tushar's best if importing to
Excel.

To add a "Print Directory" feature to Explorer, go to
this KB Article.

http://support.microsoft.com/default...EN-US;q272623&

Or you can download Printfolder 1.2 from.....

http://no-nonsense-software.com/freeware/

I use PF 1.2 and find it to be more than adequate with custom
features.

OR Go to DOS(Command) prompt and directory.
Type DIR MYFILES.TXT

All the above create a *.TXT file which can be opened in Notepad or
Excel.

One more method if you want to by-pass the *.TXT file and pull
directly to Excel is to use Tushar Mehta's Excel Add-in. This allows filtering
and sorting once you have the data in Excel.

http://www.tushar-mehta.com/ scroll down to Add-insDirectory
Listing.

Download the ZIP file and un-zip to your Office\Library folder.


Gord Dibben MS Excel MVP

On Tue, 3 Oct 2006 09:11:02 -0700, John VanNierop <John
wrote:

I am trying to combine image files taken by 4 different cameras by create
datetime. The camera times were not synced and have different date times for
the same period. I want to import the Filename and Date time Picture Taken
information into an excel file so that I can adjust the date time information
and sync the data. Any thoughts??

Gord Dibben MS Excel MVP

Thanks I will give it a try.

"CLR" wrote:

Jim Cone has a SUPER free Add-in called "ListFiles" that should do the job
nicely for you........I wouldn't be without it. It's available at

http://www.realezsites.com/bus/primitivesoftware/

Vaya con Dios,
Chuck, CABGx3




"John VanNierop" wrote:

I am trying to combine image files taken by 4 different cameras by create
datetime. The camera times were not synced and have different date times for
the same period. I want to import the Filename and Date time Picture Taken
information into an excel file so that I can adjust the date time information
and sync the data. Any thoughts??

John

In Windows Explorer open your pictures folder and right-click on the Name Column
or any other column.

Select "Date Picture Taken"

Now do your import to Excel


Gord

On Tue, 3 Oct 2006 10:14:02 -0700, John VanNierop
wrote:

The Print Directory failed to print the picture taken date time. I printed
the date the files were loaded into the directory. Will try the excel import
next.

"Gord Dibben" wrote:

John

Several methods to accomplish this.......I like Tushar's best if importing to
Excel.

To add a "Print Directory" feature to Explorer, go to
this KB Article.

http://support.microsoft.com/default...EN-US;q272623&

Or you can download Printfolder 1.2 from.....

http://no-nonsense-software.com/freeware/

I use PF 1.2 and find it to be more than adequate with custom
features.

OR Go to DOS(Command) prompt and directory.
Type DIR MYFILES.TXT

All the above create a *.TXT file which can be opened in Notepad or
Excel.

One more method if you want to by-pass the *.TXT file and pull
directly to Excel is to use Tushar Mehta's Excel Add-in. This allows filtering
and sorting once you have the data in Excel.

http://www.tushar-mehta.com/ scroll down to Add-insDirectory
Listing.

Download the ZIP file and un-zip to your Office\Library folder.


Gord Dibben MS Excel MVP

On Tue, 3 Oct 2006 09:11:02 -0700, John VanNierop <John
wrote:

I am trying to combine image files taken by 4 different cameras by create
datetime. The camera times were not synced and have different date times for
the same period. I want to import the Filename and Date time Picture Taken
information into an excel file so that I can adjust the date time information
and sync the data. Any thoughts??

Gord Dibben MS Excel MVP

A tool can print list of file in a directory easily, i use a software called Print Directory may it can solve your problem