Anyone know what the command is to collect the location of a hyperlink as a value?

Currently, I can only get the name for the cell (currently "link")

My overall objective is:

I have a sheet that has a bunch of information per row on each project. Column A contains a link to the file folder. Column B contains the project ID number. This macro will search for the ID number, then take the link to find the project, and save the workbook to the directory.

I figure it will ultimately end up looking something like this, but I really only need the hyperlink info:

Sub findsave()
pl = "\\cd\dwsfile\engineering\projects\2007\Summary.xls"
sht = "2007"
cms = ActiveWorkbook.name
Workbooks.Open pl
Dim lngfindcells As Long
For lngfindcells = 1 To 99999
If Workbooks("Summary.xls").Worksheets(sht).Cells(lngfindcells, 2).Value = Range("d7").Value Then
Workbooks(cms).SaveAs Workbooks("Summary.xls").Worksheets(sht).Cells(lngfindcells, 2).Hyperlinks.Address & "\Coverage map.xls"
Workbooks("Summary.xls").Close True
Exit Sub
Else
End If
Next
End Sub