Request Hyperlink macro code to open new image per line

**ganeshinscribe** · 05-18-2012, 04:00 AM

Dear All,

I have list of information in column A, B, C & D. I want to click if any one of this information than we need to open its respective image. The image reference is to be match with column "A".

I have attached sample for we have created manually linked in excel.

Please review and let me know if you have any questions in this regard.

Please send your idea or solutions to get this requests.

Thanks & Regards,
Ganesh

**ganeshinscribe** · 05-18-2012, 10:02 AM

Dear All,

Please help me to get solution of above my request....

Regards,
Ganesh

**ashish koul** · 05-22-2012, 10:16 AM

Remove the hyperlinks

Please Login or Register  to view this content.

use above code in worksheet change event it will work only if your files are in jpg format else i would suggest you add extra column at the end for extensions and then concatenate with the full path

**ganeshinscribe** · 05-22-2012, 10:38 AM

Sorry Ashis,

It was not functioning.. Please help me to get this solution.

Also, if click the A1, B1, C1, D1 column information than we need to open same image.

Regards,

Ganesh

**ganeshinscribe** · 05-25-2012, 02:27 AM

Hi Ashish,

I have modified small changes and it was working fine.

*****

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)

Dim strFilePath As String

If Target.Row <= Range("a60000").End(xlUp).Row And Target.Count = 1 Then

strFilePath = ThisWorkbook.Path & "\" & ActiveSheet.Cells(ActiveCell.Row, 2).Value & ".png"

ActiveWorkbook.FollowHyperlink strFilePath, NewWindow:=True

End If

End Sub

********

Thanks for your great support.

Regards,
Ganesh