Open image XXXX.png where XXXX is the cell value?

[Viceman]

What is the simpliest way to open up an image from specified folder. Where image name is cell value by clicking the cell.

For example:
I have 0123 value in A1 cell. And subfolder \pics\ in my work folder and there is a 0123.png file in pics folder. So How I can open this image by clicking the cell. I know I can do this with hyperlink for example, but if put 0124 value in A1 cell I want it to open 0124.png file then. So I can also easily copy the macro (or whatever) for other cells also.

 

[Fennek]

Hi, as a starting point:

 Sub Pic_insert() path = "c:\temp\" '<<<< adopt 'Picture-Name in A2 i = 2     ActiveSheet.Shapes.AddPicture cells(i,1) & ".png", -1, -1, 60, 60, 400, 300 End Sub

regards

 

[Viceman]

umm.. I didn't quite get this? Can you explain it a bit?

 

[jkpieterse]

=HYPERLINK("file://pics/"&A1&".png")

 

[Viceman]

I don't know why, but for some reason I dont get it to work before I put full folder path into that link

 

[jkpieterse]

Well yes, of course the full path information needs to be there, but you have not provided that information in your question (I do not know what your work folder is).