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

  • Thread starter Thread starter klj
  • Start date Start date
K

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,
 
Check out help on worksheet function.

=HYPERKLINK("c:\temp\")

If this post helps click Yes
 
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
 
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
 
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,
 
\\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
 
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
 
Back
Top