Hyperlink Text

[coless2001]

I'm trying to display the text of a hyperlink and have used many of the
methods described in this discussion group, but my links seem to have a
problem. When I right-click to "Edit Hyperlink", the link is displayed as
"..\..\Sales\Business Cases\NewProject.xls". The link works fine if you
click on it and the text displayed when you hover over the cell shows the
full path, but all of the methods to display the hyperlink show the
"...\...\". Anyone know how I can get the full path without this truncation?

 

[JLGWhiz]

It compresses or truncates because there is not enough space to show the full
text. I am not sure where you are attempting to display it, but the answer
is to provide sufficient space, use linewrap, multiline or some other feature
to provide adequate space.

 

[anant.basant]

It compresses or truncates because there is not enough space to show the full
text.  I am not sure where you are attempting to display it, but the answer
is to provide sufficient space, use linewrap, multiline or some other feature
to provide adequate space.

 

[anant.basant]

I'm trying to display the text of a hyperlink and have used many of the
methods described in this discussion group, but my links seem to have a
problem.  When I right-click to "Edit Hyperlink", the link is displayedas
"..\..\Sales\Business Cases\NewProject.xls".  The link works fine if you
click on it and the text displayed when you hover over the cell shows the
full path, but all of the methods to display the hyperlink show the
"...\...\".  Anyone know how I can get the full path without this truncation?

I am no sure what you are trying to do but if you want the link text
string only you can reach to it by pressing Ctrl+k or going to the
edit hyperlinks box on the Insert menu.

If there are a bunch of links you want the strings for you can run a
loop in VBA and get the string using the Hyperlinks object.

Hope that solves your query.

 

[Dave Peterson]

I'd try:

In xl2003 menus:
File|Properties|Summary Tab|Hyperlink Base
change it to C:\
(something that's always available)

In xl2007:
Click on the Office button
Choose Prepare, then properties.
Then use the arrow on the Document Properties dropdown
Choose Advanced Properties
And then change the hyperlink base on the Summary tab.