Opening a file when a hyperlink is clicked.
Posted by Uttam on June 14, 2001 8:17 AM
Hello,
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.
Posted by Aladin Akyurek on June 14, 2001 9:22 AM
Uttam
Try in B:
=HYPERLINK("P:\Project_1\DEFECTS_DIRECTORY\"&A1&".doc")
Aladin
Posted by Aladin Akyurek on June 14, 2001 9:29 AM
Additionally
put the bit P:\Project_1\DEFECTS_DIRECTORY\ in some cell (say in C1) and change the formula to:
=HYPERLINK($C$1&,A1,".doc")
Aladin
: Hello, : B1 contains the formula CONCATENATE("P:\Project_1\DEFECTS_DIRECTORY\",A1,".doc") : 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.)
Posted by Uttam on June 14, 2001 10:10 AM
Re: Additionally
put the bit P:\Project_1\DEFECTS_DIRECTORY\ in some cell (say in C1) and change the formula to:
Alladin,
Sorry but it does not seem to work. The actual entries are slightly different, though IMHO, they should not cause failure.
The actual entries are in Columns A, F and G. Column A contains "DEFECT1123". Column F contains the complete file path including drive letter. While Column G contains the following Formula: =HYPERLINK(F1,"Open Document")
I get a message "Cannot open specified file". I have confirmed that the file exists in the appropriate subdirectory.
As a matter of testing, I create an Excel File instead of a Word Document and changed the formula to concatenate ".xls" in place of (what I really want) ".doc" and lo and behold! The xls file is opened normally.
Hope you can help me in this.
Thanks in advance
Posted by Uttam on June 14, 2001 10:15 AM
Re: Additionally
put the bit P:\Project_1\DEFECTS_DIRECTORY\ in some cell (say in C1) and change the formula to:
Alladin,
Sorry but it does not seem to work. The actual entries are slightly different, though IMHO, they should not cause failure.
The actual entries are in Columns A, F and G. Column A contains "DEFECT1123". Column F contains the complete file path including drive letter. While Column G contains the following Formula: =HYPERLINK(F1,"Open Document")
I get a message "Cannot open specified file". I have confirmed that the file exists in the appropriate subdirectory.
As a matter of testing, I create an Excel File instead of a Word Document and changed the formula to concatenate ".xls" in place of (what I really want) ".doc" and lo and behold! The xls file is opened normally.
Hope you can help me in this.
Thanks in advance
Posted by Aladin Akyurek on June 14, 2001 11:22 AM
Re: Additionally
Uttam
I have the following in G8
Vegeta:Documents:@MrExcel:IFx.doc
=HYPERLINK(G8)
creates a clickable hyperlink. Clicking on the link so created causes the opening of IFx.doc.
Try the above form.
Aladin
Posted by Aladin Akyurek on June 14, 2001 11:25 AM
Re: Additionally
Tested on the Mac, but that shouldn't matter. I have the following in G8 Vegeta:Documents:@MrExcel:IFx.doc =HYPERLINK(G8) creates a clickable hyperlink. Clicking on the link so created causes the opening of IFx.doc. Try the above form.
