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 :confused:
All I'm left with is the file path info but not linking to anything.

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.

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