MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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.