Hyperlink Problems when exporting to excel (1 Viewer)

[Groundrush]

Anyone know how to keep the hyperlinks when exporting to excel?

My db table has a field called FilePath & I've set the data type to Hyperlink
which is great when viewing the links via a query but for some reason when I export the data to exel the hyperlinks do not move across
All I'm left with is the file path info but not linking to anything.

 

[the_net_2.0]

I think I saw something here that changes text to hyperlinks in Excel. It might be in the Samples section.

And if I'm also right again, I don't think you can prevent this, but I may be wrong. I've seen other posts about the problem elsewhere.

 

[Groundrush]

I found this solution that you add to a macro in excel.

Public Sub Convert_To_Hyperlinks()
    Dim Cell As Range
    For Each Cell In Intersect(Selection, ActiveSheet.UsedRange)
        If Cell <> "" Then
            ActiveSheet.Hyperlinks.Add Cell, Cell.Value
        End If
    Next
End Sub