| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to check for recurrence of same names in column 1 and column | Excel Discussion (Misc queries) | |||
| Importing data to column from column with differnet names | Excel Discussion (Misc queries) | |||
| How to link a column with the other file | New Users to Excel | |||
| how do I save a column to a file (in ascii format) | Excel Discussion (Misc queries) | |||
| Column A is Town, Column B is names. How can Excel add & tell how. | Charts and Charting in Excel | |||
Threaded Mode
