B
Brettjg
Hi there, I've been working with Gord Dibben on a very strange problem with
folder openings. Gord's fixes solved the initial problem, but now there is a
new set of problems, and Gord is out of ideas (not surprising, because it's
very, very wierd).
I need to briefly explain my folder hierarchy:
On C drive there is a folder "1. ACTIVE CLIENTS"
within that there are many client folders
within each of them, there may or may not be subfolders.
Also, I have my main workbook called "TOOLS" which is always open, and it
has a sheet that has a whole bunch of text boxes with hyperlinks on it so I
can open any folder I need easily. Hyperlinks being the sensitive little
critters that they are, I have created a macro that recreates them (necessary
because when Excel 2003 crashes - which it does ALL the time, the hyperlinks
get changed and I have to recreate them).
So now there are three different things happening:
1. Via a macro, if I create the hyperlink to a client folder using "../1.
ACTIVE
CLIENTS/Dibben, G" the "Dibben, G" folder opens perfectly, but when I open
any sub folder it says the path does not exist or is not a directory.
2. Via a macro, if I create the hyperlink to a client folder using "C:\1.
ACTIVE
CLIENTS/Dibben, G" the "Dibben, G" folder gets a virus warning, but
subfolders open perfectly. There are no "confirm open" boxes checked in
folder options for File Folders or Folders.
3. (and the strangest of all) The hyperlink to "1. ACTIVE CLIENTS" uses (and
has always used) "../1. ACTIVE CLIENTS". It opens perfectly, and when I go
into a client folder, they open perfectly, as do the client subfolders.
This whole fiasco came about because of a new routine in a different place
(but using identical code), where I was trying to create an individual Client
folder in ACTIVE CLIENTS. When I used the "../1. ACTIVE CLIENTS" code there
it always added "../1. ACTIVE CLIENTS/1. ACTIVE CLIENTS\Dibben, G" and so of
course could not find the folder because of the double /1. ACTIVE CLIENTS in
the path. That's why I reverted to "C:\1. ACTIVE CLIENTS" BUT ONLY IN THIS
NEW PIECE OF CODE, AND THIS IS WHEN I FIRST STARTED TO GET THE VIRUS WARNINGS.
So what do you think might be going on? Or are you now as befuddled as Gord
and I are? Regards, Brett.
folder openings. Gord's fixes solved the initial problem, but now there is a
new set of problems, and Gord is out of ideas (not surprising, because it's
very, very wierd).
I need to briefly explain my folder hierarchy:
On C drive there is a folder "1. ACTIVE CLIENTS"
within that there are many client folders
within each of them, there may or may not be subfolders.
Also, I have my main workbook called "TOOLS" which is always open, and it
has a sheet that has a whole bunch of text boxes with hyperlinks on it so I
can open any folder I need easily. Hyperlinks being the sensitive little
critters that they are, I have created a macro that recreates them (necessary
because when Excel 2003 crashes - which it does ALL the time, the hyperlinks
get changed and I have to recreate them).
So now there are three different things happening:
1. Via a macro, if I create the hyperlink to a client folder using "../1.
ACTIVE
CLIENTS/Dibben, G" the "Dibben, G" folder opens perfectly, but when I open
any sub folder it says the path does not exist or is not a directory.
2. Via a macro, if I create the hyperlink to a client folder using "C:\1.
ACTIVE
CLIENTS/Dibben, G" the "Dibben, G" folder gets a virus warning, but
subfolders open perfectly. There are no "confirm open" boxes checked in
folder options for File Folders or Folders.
3. (and the strangest of all) The hyperlink to "1. ACTIVE CLIENTS" uses (and
has always used) "../1. ACTIVE CLIENTS". It opens perfectly, and when I go
into a client folder, they open perfectly, as do the client subfolders.
This whole fiasco came about because of a new routine in a different place
(but using identical code), where I was trying to create an individual Client
folder in ACTIVE CLIENTS. When I used the "../1. ACTIVE CLIENTS" code there
it always added "../1. ACTIVE CLIENTS/1. ACTIVE CLIENTS\Dibben, G" and so of
course could not find the folder because of the double /1. ACTIVE CLIENTS in
the path. That's why I reverted to "C:\1. ACTIVE CLIENTS" BUT ONLY IN THIS
NEW PIECE OF CODE, AND THIS IS WHEN I FIRST STARTED TO GET THE VIRUS WARNINGS.
So what do you think might be going on? Or are you now as befuddled as Gord
and I are? Regards, Brett.