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.x ls
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.
--
*********************
J Streger
MS Office Master 2000 ed.
MS Project White Belt 2003