Script to add hyperlink to Excel cell containing text
Hi,
No need of a script, you can use the HYPERLINK( path , displayed_text)
funtion:
Say column A contains the file names, eg: a2: BE001.TXT
-In B2: =HYPERLINK("\\Server06\C$\Program Files\Veritas\NT\Data\" & A2, A2)
-Copy/Paste down this cell along the data
- you can even hide column A now if necessary (select column A, then menu
Format Column Hide)
Regards,
Sebastien
"John Doe" wrote:
Would like to use Windows Script to add a hyperlink to a cell in Excel:
Example:
The cell contains BE001.TXT. I want to turn that entry into a hyperlink to
\\Server06\C$\Program Files\Veritas\NT\Data\BE001.TXT while displaying only
BE001.TXT in the cell.
Can this be done using Windows Scripting?
Please reply to the group -no emails.
Thanks in advance
|