Batch Hyperlinking from Outside Folder

Just hoping to get some help with this problem I am having in excel 2007.

I have an excel file with close to 2,000 part numbers of which i would like batch hyperlink them their corresponding pictures in a folder of 1,000 pictuers. One thing to note, the picture file name and the part number are the exact same format.

I would like to somehow automate a process of searching through these pictures for a match to the excel file and if there is a match, make a hyperlink of that part number that when clicked on, will pop up with the picture of the part.

Thanks,
Any help would be greatly appreciated.

Like so...put this hyperlink formula in column A with your part numbers in column B, your folder path in H2 and your picture extension in G2:

=HYPERLINK($H$2 & B2 & $G$2, "Link")

I applied your spreadsheet with my own values and could not get the picture in cell column B to appear upon being clicked on

The only thing that would happen when i would open it is the folder itself with the pictures in it
I wanted to see if it would actually search for that picture name and make a link to the actual picture so that when you click the link you see the photo image not just the file in a folder.

thanks

I know it seems wrong, but the problem is the [ ] brackets you placed around your path. You should trust the example I gave you works because I wouldn't post it unless I'd already tested it.

Match your example to mine in row 2, we are creating a windows link, not an Excel link. Just try it. The syntax I showed creates links that opens your default picture viewer and displays the picture if it's in the exact location created by the text strings. For you example, the result need to be:

C:\Documents and Settings\All Users\Documents\My Pictures\Sample Pictures\1000550719.jpg

So in H7, not only do you need to remove the [ ] brackets, you need to put the \ back at the end.

This is all on you now. I've shown the exact proper syntax. The only thing that would keep this from working for you is a misspelling.

Make sure you try this with more than one file name and possibly more than one path. This does work exactly as shown. You need only verify the path is correct and the filename is spelled exactly right. There are no secrets to this beyond that.

If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.

There are no builtin Excel functions to complete that test for you. I've been trying to keep you from needing VBA at all, accomplish your linking using simple formulas.

The only way to "test" the links is to use VBA and change the cell results permanently if the file doesn't exist:

Please Login or Register  to view this content.

If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.