Format column to link file names in that column

[desiaashik]

I have a VBScript that takes snapshot of my automation tests that I do. Every
run takes a snapshot and stores that into a separate row in excel with the
file name and location in "snapshot file" column.

For e.g. My snapshot column would have following entries

C:\Automation\Snapshots\Image # 1.png
C:\Automation\Snapshots\Image # 2.png
C:\Automation\Snapshots\Image # 3.png

What I want is to automatically make these entries a link so that when I
click on the location (say...C:\Automation\Snapshots\Image # 1.png), the
image automatically opens up

Is there any easy way or any other way to do this formatting of column?

 

[Sheeloo]

Use a statement like the one below
ActiveSheet.Hyperlinks.Add Anchor:=Range("A1"), Address:="Shuffle.xls" _
, TextToDisplay:="Shuffle.xls"

Shuffle.xls is a file in the same directory as the activeworkbook... You can
add complete/relative path

 

[Gary''s Student]

In B1 enter:
=HYPERLINK(A1,A1) and copy down to produce a nice list of "clickable"
hyperlinks