Find Pictures and Hyperlink
 

I do a lot of stuff with pictures and hyperlinking them in excel. I have a
column labled picture ID number, which, for example, would have "1898" in a
cell and the filename of the picture would be "IMG_1898." I was wondering if
there is a way of writing a function or something in which the program
searches for the picture I want based on the number in that column, without
me having to find the picture myself and hyperlink it. It would make things
a lot faster for me if I could find a quicker way to do this.

Like this:

http://www.mcgimpsey.com/excel/lookuppics.html

Do you mean you want to hyperlink to a picture file on a drive somewhere?

If yes, maybe you could use a helper cell with an =hyperlink() formula.

If 1898 was in A1.

=HYPERLINK("file:////c:/my documents/my pictures/img_"
& TEXT(A1,"0000") & ".jpg")

(all one cell)



TimelessTreasuresVP wrote:

I do a lot of stuff with pictures and hyperlinking them in excel. I have a
column labled picture ID number, which, for example, would have "1898" in a
cell and the filename of the picture would be "IMG_1898." I was wondering if
there is a way of writing a function or something in which the program
searches for the picture I want based on the number in that column, without
me having to find the picture myself and hyperlink it. It would make things
a lot faster for me if I could find a quicker way to do this.

--

Dave Peterson

I think that your suggestion would actually work with an older version of
windows, like 98, that uses the explorer window to open the file. I use xp
and it uses windows picture and fax viewer to open up my pictures, which
means that the hyperlink that your function creates will not work. Any other
suggestions?


"Dave Peterson" wrote:

Do you mean you want to hyperlink to a picture file on a drive somewhere?

If yes, maybe you could use a helper cell with an =hyperlink() formula.

If 1898 was in A1.

=HYPERLINK("file:////c:/my documents/my pictures/img_"
& TEXT(A1,"0000") & ".jpg")

(all one cell)



TimelessTreasuresVP wrote:

I do a lot of stuff with pictures and hyperlinking them in excel. I have a
column labled picture ID number, which, for example, would have "1898" in a
cell and the filename of the picture would be "IMG_1898." I was wondering if
there is a way of writing a function or something in which the program
searches for the picture I want based on the number in that column, without
me having to find the picture myself and hyperlink it. It would make things
a lot faster for me if I could find a quicker way to do this.

--

Dave Peterson

Why wouldn't it work?

What happened when you tried it?

TimelessTreasuresVP wrote:

I think that your suggestion would actually work with an older version of
windows, like 98, that uses the explorer window to open the file. I use xp
and it uses windows picture and fax viewer to open up my pictures, which
means that the hyperlink that your function creates will not work. Any other
suggestions?

"Dave Peterson" wrote:

Do you mean you want to hyperlink to a picture file on a drive somewhere?

If yes, maybe you could use a helper cell with an =hyperlink() formula.

If 1898 was in A1.

=HYPERLINK("file:////c:/my documents/my pictures/img_"
& TEXT(A1,"0000") & ".jpg")

(all one cell)



TimelessTreasuresVP wrote:

I do a lot of stuff with pictures and hyperlinking them in excel. I have a
column labled picture ID number, which, for example, would have "1898" in a
cell and the filename of the picture would be "IMG_1898." I was wondering if
there is a way of writing a function or something in which the program
searches for the picture I want based on the number in that column, without
me having to find the picture myself and hyperlink it. It would make things
a lot faster for me if I could find a quicker way to do this.

--

Dave Peterson


--

Dave Peterson

lol...Nevermind, I found the problem (it was a mistake on my part). Thanks
for your help; it will save me a whole lot of time.


"Dave Peterson" wrote:

Why wouldn't it work?

What happened when you tried it?

TimelessTreasuresVP wrote:

I think that your suggestion would actually work with an older version of
windows, like 98, that uses the explorer window to open the file. I use xp
and it uses windows picture and fax viewer to open up my pictures, which
means that the hyperlink that your function creates will not work. Any other
suggestions?

"Dave Peterson" wrote:

Do you mean you want to hyperlink to a picture file on a drive somewhere?

If yes, maybe you could use a helper cell with an =hyperlink() formula.

If 1898 was in A1.

=HYPERLINK("file:////c:/my documents/my pictures/img_"
& TEXT(A1,"0000") & ".jpg")

(all one cell)



TimelessTreasuresVP wrote:

I do a lot of stuff with pictures and hyperlinking them in excel. I have a
column labled picture ID number, which, for example, would have "1898" in a
cell and the filename of the picture would be "IMG_1898." I was wondering if
there is a way of writing a function or something in which the program
searches for the picture I want based on the number in that column, without
me having to find the picture myself and hyperlink it. It would make things
a lot faster for me if I could find a quicker way to do this.

--

Dave Peterson


--

Dave Peterson