Back from my holidays, with a hard disk full of holiday snaps, and looking for a program to extract the image data saved on the camera, and add comments. Not liking the offerings provided with the cameras, or any of the free programs I found, I have written my own, using ImageMagick.
ImageMagick is a command line image manipulation program, which has COM+ component, allowing the program functionality to be accessed from VBA. More details here: ImageMagick COM+ object
My image importer program can be downloded from: PastePic.zip, and screenshots are shown below.
To run the program you will need to download and install the ImageMagick software, then in the Visual Basic editor create a reference to the ImageMagickObject 1.0 Type Library, using the Tools-References menu.
The spreadsheet file has only been provided in Excel 2007 format because in earlier versions the file size becomes impracticably large with only a small number of images.