Hyperlink with pound sign in filename

P

Pierre-Yves

Hi,

I'm looking for a tips in MS EXCEL 2000 to build an
hyperlink to a file that has a "#" (pound character hex
23, decimal 35) in the file name.

With regular file name there's no problem.

I tried to code with %23 in place of the # in the url but
it doesn't work.

Thank's by advance

PY
 
M

Myrna Larson

Maybe it isn't possible. I just tried doing it manually. I selected a file
with a name like this, and the link was added, but the properties show " - "
instead of the pound sign, and clicking on the link says the file can't be
found.
 
F

Frank Kabel

Hi
the reason for this could be that the pund sign (#) is also used in
Excel to reference a specific sheet within the file
 
A

Allan S. Warrior

A # symbol in an href attribute usually signifies a link to a named anchor
within the file named prior to the # sign. Since your # sign is part of the
file name and not signifying content within the document, you get a 404 file
not found error. I don't think you'll easily be able to fool your
applications around this. It would be better to rename your file.
 
D

David McRitchie

Hi Pierre-Yves,
Is this for an Excel file, and are you on a Mac or on a PC.
The the part after the # is called a fragment id and is not considered part
of the URL. I don't expect you would be able to put a filename that includes
a # on a web server. Why are you trying to do this.

FWIW, I know it is a fragment id because I never had a problem with
using it (that I was aware of) until I found that Firefox (internet browser)
was case sensitive even though it was in the document. In the HTML
standard the fragment must be unique within a document without regard
to capitalization. But how it appears in lettercase is not defined, yet some
browsers will test and fail if not consistent. (IE is not one of those browsers).

http://www.w3.org/TR/html4/struct/links.html#h-12.2.1
Although the following excerpt is legal HTML, the behavior of the user agent
is not defined; some user agents may (incorrectly) consider this a match and
others may not. //applies to the letter case of the fragment identication//
 
P

Pierre-Yves

Hi David and other writers,

Thank you for your answers.

I'm on PC platform and I don't try to reach a web server :
only my own PC or a local server (All windows)

The goal is to build a inventory of all files in directory
and subdirectory from a specified root chosen by the user.
I build a hierarchical list and for each item, I put an
hyperlink in the cell to be able to quickly acces the file
or directory if desired; it works fine until I reach "#"
in some file names. The names in the list are well written
(for directory and files) but the hyperlinks
give "Impossible to open the specified file" (free
translation : I'm in french Excel).

I begin to think that's not possible to bypass.

Thanks a lot

PY
-----Original Message-----
Hi Pierre-Yves,
Is this for an Excel file, and are you on a Mac or on a PC.
The the part after the # is called a fragment id and is not considered part
of the URL. I don't expect you would be able to put a filename that includes
a # on a web server. Why are you trying to do this.

FWIW, I know it is a fragment id because I never had a problem with
using it (that I was aware of) until I found that Firefox (internet browser)
was case sensitive even though it was in the document. In the HTML
standard the fragment must be unique within a document without regard
to capitalization. But how it appears in lettercase is not defined, yet some
browsers will test and fail if not consistent. (IE is not one of those browsers).

http://www.w3.org/TR/html4/struct/links.html#h-12.2.1
Although the following excerpt is legal HTML, the behavior of the user agent
is not defined; some user agents may (incorrectly) consider this a match and
others may not. //applies to the letter case of the fragment identication//
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Pierre-Yves" <[email protected]> wrote
Click to expand...
in message news:[email protected]...
 
Top