Preserving the Hyperlink using DoCmd.TransferSpreadsheet

[Beans]

Hi, I have a field that is configured as a hyperlink but when I export it
using a query and the DoCmd.TransferSpreadsheet the hyperlink is converted to
text.

Interestingly enough if I export the table using Tools Office links and
analyze it with Microsoft Excel, the hyperlinks are preserved.

Any suggestions.

thanks

 

[Lord Kelvan]

well you could always use the vba code for analyse it with excel not
that i know what it is this question is better for a vba group they
should be able to help you