LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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?

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to check for recurrence of same names in column 1 and column JillyB Excel Discussion (Misc queries) 1 January 30th 07 02:11 PM
Importing data to column from column with differnet names bey12 Excel Discussion (Misc queries) 1 August 4th 06 12:39 AM
How to link a column with the other file vsr_kmb New Users to Excel 2 April 11th 06 07:25 AM
how do I save a column to a file (in ascii format) joe Excel Discussion (Misc queries) 4 June 26th 05 12:59 AM
Column A is Town, Column B is names. How can Excel add & tell how. Cindy Charts and Charting in Excel 3 January 13th 05 07:27 PM


All times are GMT +1. The time now is 12:18 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"