Format column to link file names in that column
 

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?

Format column to link file names in that column
 

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?

Format column to link file names in that column
 

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

--
Gary''s Student - gsnu200841


"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?