Opening a file when a hyperlink is clicked.
Posted by Uttam on June 14, 2001 8:17 AM
A1 contains the text "DEFECT1123"
B1 contains the formula CONCATENATE("P:\Project_1\DEFECTS_DIRECTORY\",A1,".doc")
The same formulas are repeated in Column B in subsequent rows also. And A2 may contain "DEFECT1135", A3 may contain "DEFECT1303" and so on.
I would like to do the following:
Define contents in Column B as Hyperlinks.
Whenever a Cell in Column B is clicked, the relevant file should be opened (so when B1 is clicked, DEFECT1123.doc should be opened while B2 is clicked, DEFECT1135.doc should be opened.)
Can anyone help?
Thanks in advance.