Hyperlink problem with percents
 

This seems to only happen with Excel 2003 and XP

Lets say I have a file such as:
C:\Group A\[1]Movie.mpg

and this link should work

When I go to edit this link this is what it provides:
Group%20A/%5b1%5dMovie.mpg

This link does not work

Notice that the Slashes switch
Also that %20 is a space
%5b is [ and %5d is ]

When you move your cursor over the link and look at its path it shows
Group A/%5b1%5dMovie.mpg

Apparently %20 works and gives the space, and it does when i use links to
files without [ or ]

So therefore the problem lies with [ and ] and that %5b and %5d are not
doing their job.

How can I go about fixing this problem, and yes the file must contain [ and
] in them.

It is for this reason I never uses spaces in file names!
You are correct - in hyperlinks a space become %20
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"MLange2064" wrote in message
...
This seems to only happen with Excel 2003 and XP

Lets say I have a file such as:
C:\Group A\[1]Movie.mpg

and this link should work

When I go to edit this link this is what it provides:
Group%20A/%5b1%5dMovie.mpg

This link does not work

Notice that the Slashes switch
Also that %20 is a space
%5b is [ and %5d is ]

When you move your cursor over the link and look at its path it shows
Group A/%5b1%5dMovie.mpg

Apparently %20 works and gives the space, and it does when i use links to
files without [ or ]

So therefore the problem lies with [ and ] and that %5b and %5d are not
doing their job.

How can I go about fixing this problem, and yes the file must contain [
and
] in them.