Problem opening folders with hyperlink (URGENT)

[Brettjg]

I posted this question last night and Rick Rothstein gave me a possible
solution, but to no avail. Suspect Rick is not around at the moment becuse of
time zone differences, and I really need a solution urgently (because I can't
open heaps of folders):

I have a whole bunch of =HYPERLINK functions on one particular page. Every
now and then I have to recreate a certain group of them because of client
name list changes. All of the old ones such as:
=HYPERLINK("C:\0. QUO VADIS\","0. QUO VADIS")
still work properly, but now the new ones that are created e.g:
=HYPERLINK("C:\2. SETTLED CLIENTS\Dunn, P","Dunn, P")
come up with an error msg that the path "P" does not exist or is not a
directory. This has nothing to do with the comma in the folder name because
they have always been there. I can still open the folders by drilling down
from the top, so there's nothing wrong with them.

This came about because of the other problem that I'm having: when these
hypelinks do work (in a previous life) the folders open up subfolders in
separate windows, even though I have "same window" checked in folder options.
I noticed that if I used "Explore" instead of "open" then the same window was
used. So then I set a new default action of Explore
"C:\Windows\explorer.exe". I think I may have inadvertantly put the quote
marks in as well, but I can't remove the action now (or edit it). I notice in
the "Open" action that there is a checkbox for "Browse in same Window" but it
can't be checked. I think that would solve my separate windows problem, but
that is secondary to not being able to open them at all via = HYPERLINK


The only other thing that I changed was in the Worksheet_selectionchange
code, but because the new code didn't do what I wanted I commented it out.

I've restored the previous version of the workbook, but it does the same. I
have proved that it's not the hyperlink formula, but don't know what to try
next.

Thanks for any help offered. Brett

 

[JLGWhiz]

Like Rick, I don't use hyperlinks, but it is pretty clear from reading the
help file description of the HYPERLINK function, that if you use the correct
path, there should be not problem. So be sure your path data is spelled
correctly, that all back slashes are in the correct place and that no
unautorized characters are used in file or forlder names. It seem pretty
simple when you read it, but there is always a chance that something will go
wrong.

 

[Brettjg]

Hi JLG, thanks for your response. I know that the formula is correct because
nothing has changed, and the QUO VADIS file opens perfectly. The problem
seems to have come about when I created the action "Explore", but the default
is now "Open" (which always worked, but opened folders in a separate window).
Do you have any other ideas please? The msg I get is "Path "P" does not exist
or is not a directory" but "P" is only the last character of the path in the
hyperlink formula.

 

[Janet]

I am using the HYPERLINK function in excel and each time I click on one of
the links, it opens up a new window. I would like to use the same window so I
dont have to log each time. How do I stop excel from opening a new window?

Janet

 

[Brettjg]

Hi Janet, I wish I knew. I assume that in Folder Options you have "open in
same window" checked. Brett