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

"desiaashik" wrote:

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?