Hyperlinks being cropped upon save.

[J Streger]

I am adding hyperlinks to a sheet using a GetsaveAsFilename method . I am
using using file references to a shared server with these parameters:

Address: \\Servername\Partitionname\Folder1\Folder2\excel.xls
TexttoDisplay: Excel.xls

I do this so the user sees which file they have chosen, without the 6 levels
interfering.

This works fine...until I save the document. When I save the document, the
File name in the hyperlink crops down to just 'Folder2\excel.xls'. Now the
file will still open correctly if checked, and the screentip still shows the
full location, with server name etc.

Now I am writing procedures that need to read the Address from the Hyperlink
for each cell, but the address property was also cropped down to
'Folder2\Excel.xls,' and that is throwing out errors.

I then looked in the Hyperlink dialogue box and saw the full addresses I
inputted under the inserted linked section. When I click on those the Type of
File or Web Page name text box still only showed the cropped version. Now
it's only for this server. If I link to other servers I don't get this issue.
I have tried both adding the hyperlink manually and programatically with the
same results.

Help! Thanks.

 

[Dave Peterson]

Some people have written that changing the hyperlink base
(File|properties|Summary tab)

to something like
C:\
(that's always available)
will make the hyperlinks not change.

ps. I like to use the =hyperlink() worksheet function. I've never had any
trouble with them.

 

[J Streger]

Thanks a lot. THe C:\ fix worked.

I wanted to stay away from the hyperlink formula since I think it would take
a few more steps later to open the sheets and link to them.

Thanks for your help!
--
*********************
J Streger
MS Office Master 2000 ed.
MS Project White Belt 2003