Hi guys!

I have cells where I create a link to a different file. In code I need to get the value of the link. Simple enough using .Value but if I move the folder to a different folder location then it updates the links automatically but the .Value is still the old link.

for example I link in the cell and it puts the value as
\\UNCpath\folder\file.xls

links to \\UNCpath\folder\file.xls
.Value = \\UNCpath\folder\file.xls

but if I move the folder to a local drive it leaves the .Value the same but knows enough to change the link to
C:\folder\file.ext

links to C:\folder\file.ext
.Value = \\UNCpath\folder\file.xls

I need to get this actual link in code... any thoughts?

Kappy