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?