Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
Like this:
http://www.mcgimpsey.com/excel/lookuppics.html Quote:
__________________
Justin Labenne www.jlxl.net |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
#6
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
converting hyperlink paths | Excel Discussion (Misc queries) | |||
adding pictures to an excel file that are on a cd | Excel Discussion (Misc queries) | |||
a quick way to hyperlink 2000 of cells ? | Excel Discussion (Misc queries) |