Problem Opening Folders (again)
 

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.

Thanks for any help offered. Brett

Problem Opening Folders (again)
 

=HYPERLINK("C:\2. SETTLED CLIENTS\Dunn, P","Dunn, P")

I'm not all that familiar with hyperlinks, so I may be completely off base
here... should there be a backslash after the directory path?

=HYPERLINK("C:\2. SETTLED CLIENTS\Dunn, P\","Dunn, P")

--
Rick (MVP - Excel)


"Brettjg" wrote in message
...
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.

Thanks for any help offered. Brett

Problem Opening Folders (again)
 

Hi Rick, including a backslash doesn't make any difference except that it
can't find the file "P\". The weird thing is that in the cell next to it I
have:
=HYPERLINK("C:\2. SETTLED CLIENTS\Dunn, P\0. INTERFACE SETTLED Dunn.xls","I")
to open the client's interface file and it works perfectly (they are
recreated at the same time). That indicates to me that it's not a VB coding
problem, but a problem windows or something.

I haven't changed the VB code at all from what it used to be.
Regards, Brett

"Rick Rothstein" wrote:

=HYPERLINK("C:\2. SETTLED CLIENTS\Dunn, P","Dunn, P")

I'm not all that familiar with hyperlinks, so I may be completely off base
here... should there be a backslash after the directory path?

=HYPERLINK("C:\2. SETTLED CLIENTS\Dunn, P\","Dunn, P")

--
Rick (MVP - Excel)


"Brettjg" wrote in message
...
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.

Thanks for any help offered. Brett