Auto hyperlink to files???

[mickey331]

Hi everybody!
I am new here and I searched the forum but did not find a solution...

I am creating list of completed tasks in a workshop (about 1000 of them) and i need to link every part number to a drawing in jpg format on my HD.

So I was thinking, is it possible when you type the part number in cell to be automatically linked to file with the same name?

Thanks!
Regards from Serbia!

[JBeaucaire]

Sure!

Assuming the path is always the same and just part number of the pic is the variable, assuming the cell you are typing a part number in is A2, then this formula in B2 will present a hyperlink construction:

=HYPERLINK("C:\2010\Pics\" & A2 & ".gif", "Link to: " & A2)

Or this:

=IF(A2="", "", HYPERLINK("C:\2010\Pics\" & A2 & ".gif", "Link to: " & A2))

[mickey331]

Thanks!!! It works perfect!

[JBeaucaire]

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

[mickey331]

Problem is solved, but it would be even better if excel could recognize if there is a file in my folder. And if I don't have a file with that name to leave an empty cell (I mean without "link: image name"). There are some parts in my list that I don't have pictures for, and it looks confusing

[JBeaucaire]

That's why I gave you the second version of the formula above. Leave the first cell blank when there's no image and the formula will leave a blank cell.

[mickey331]

I understend that, but first cell is full (allways, every part has his number) but every number doesn't have image that need to be linked. So it shows in second cell "Linked to: image name" but there is no image in folder. It allways shows link even if image doesn't exist.

[mkolmos]

Did you ever get this solved? I have the same issue and cannot figure it out.
Thanks

[mickey331]

Tried to solve it with VB but I gave up and used solution that JBeaucaire gave me.