HyperLink to a folder on other drive on the same network (LAN)

[klj]

Objective:
I am craeting a list of folders with titles (names), like index, using
Excel. The objective is, when a user clicks on the folder name, the link
should open the folder. All folders are on different drives / locations on
the network.

Procedures:
I have created the list and hyperlink to each folder location. The list
works fine until I close the file and reopen it.

Problem:
When I reopen the file, folders on the same drive, where the excel files is
saved, would open and all other links would be disabled. When I save the file
as webpage and go back to the Excel file everything is working fine. In other
words everytime I open the Excel file, I have to save it as webpage before I
can use the file!

Is there any alternative procedure to create such a list?

Thanks,

 

[Jacob Skaria]

Check out help on worksheet function.

=HYPERKLINK("c:\temp\")

If this post helps click Yes

 

[klj]

Thanks Jacob for the response. I read most of the threads pertaining to the
hyperlink on this group. I found similar problems but not answered! Here is
the one back from 2006.....

Question
Subject: Hyperlink Problem 11/2/2006 5:45 AM PST

By: Globe Director In: microsoft.public.excel.worksheet.functions


From a worksheet (Excel Office 2003) on my computer I create a hyperlink to a
Word file on our server. All works fine until I save the worksheet, which
changes the hyperlink address, so it no longer functions. The changes are;
it removes the drive letter and adds %20 in front of each word in the
address. Can you help?
....................
I forgot to mention that I am using Office 2003. As I mentioned earlier I
have no problem with the hyperlink when I define/link them to a cell. Problem
comes only when I close the file and reopen it, the hyperlink references
change. To workaround, I have to save the file as webpage. Then all the links
in the Excel starts working fine.

Once again thanks in anticipation.

KLJ

 

[Jacob Skaria]

I dont think you have tried this.; have you? This is a formula. does that
change?

=HYPERKLINK("c:\temp\")

'OR to a file
=HYPERLINK("file:////c:\book11.txt","book11.txt")

If this post helps click Yes

 

[klj]

I tried the formula you mentioned. It does not work for the destination on
the network. Here is the location of the folder which I am trying to access
using the hyperlink. The 'friendly name' is 2118. I tried the formula with "
" and without. It gives the same result.

=HYPERLINK("\\tfile\Partitions\2\Projects\2118 Yellowhead TD", 2118)

I noticed that when I save the Excel file as webpage the hyperlink address
changes from ,
.../../../Partitions/2/Projects/2118%20Yellowhead%20TD

to,
\\tfile\Partitions\2\Projects\2118 Yellowhead TD

Thanks for your help and hope to find solution to the problem.

Regards,

 

[Jacob Skaria]

\\tfile\Partitions\2\Projects\2118 Yellowhead TD

Copy the above path and paste that to windows explorer 'Address Bar'. Do you
get that folder opened....If you can then the below should work..

=Hyperlink("\\tfile\Partitions\2\Projects\2118 Yellowhead TD","2118")

If this post helps click Yes

 

[klj]

Yes, the link works on the windows explorer and it also works in Excel when
entered. However the problem occures when I close the excel file and reopen
the same file, the links change as mentioned in previous message.

Thanks for being patient, I really appreciate your help.

klj