hyperlinks with # symbol

B

bbartsch

I am trying to creat a hyperlink in excel to open a file that has the
# symbol in the filename and it will not work. if I change the #
symbol to some other symbol it will work, but the software that i
surrently use automatically names multiple files using the # symbol.

Is there any way to get around this? I am not an excellent excel user
but I do know quite a few things about it.

ANY help would be appreciated!!!


Brian
 
S

Steve Rindsberg

I am trying to creat a hyperlink in excel to open a file that has the
# symbol in the filename and it will not work. if I change the #
symbol to some other symbol it will work, but the software that i
surrently use automatically names multiple files using the # symbol.
Click to expand...

# has a special meaning in hyperlinks, which have the general form:

Address#SubAddress

The routine that parses the link is probably stopping at the # and taking
everything to the left of it to be the filename, everything to the right to be
a location within the file.

Since you can't change the innards of Excel, you'll probably have to rename the
file you're linking to.

There are utilities that let you do batch renaming; perhaps one of these could
replace all of the # characters with something safe like an underscore _
character.

You might want to let the developer of the other software know about the
problem too.
 
Top