Excel 2007 - Search function - Photos

[snuggman]

Good evening folks,

I would like ability to search for photo's via excel, throughout my c drive.

I have MS excel 2007, I have 2000 photos, each identified by numbers.

I would like the ability to input say number photo "356" and excel searches a specific folder, auto sizes, and shows the photo.

I know very little about excel, and any help would be great.

I'm kinda looking for something like a search field within excel, for photos.

I input the picture number and it shows the picture.

cheers,
Snuggman

[Santy]

The function in Microsoft Excel is possible. But that cannot be done via simple formula. There is need of VB script that can provide you information on the basis of image search. On the other hand the issue is that if you have a large number of images then you will need to insert a hyper link in Microsoft Excel and for the Photo ID you will need to use vlookup. But if the photo is moved then all links in excel will fail to work.Here is a sample.

The formula is :

=HYPERLINK("C:\Documents and Settings\User\My Documents\My Pictures\neo.jpg")

Now this is your image link with location. On the previous cell you can assign Photo ID and then use vlookup to search the images. This will consume a big time.

You can try any image manager.

[jaxter]

The search function is possible for data and pictures. There is some simple command for item searching on excel sheet is Alt + F and other for picture searching - Make photo ID and use Vlookup function for picture
the Formula is
=HYPERLINK (""C:\Documents and Settings\User\My Documents\My Pictures\neo.jpg")