Preserving the Hyperlink using DoCmd.TransferSpreadsheet

  • Thread starter Thread starter Beans
  • Start date Start date
B

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
 
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
 
Back
Top