I've got a query that contains a field called "URL", that field is a hyperlink field. I've got these super long hyperlinks in this field for different records, and for some reason, when I export them to excel, the URL's appear to be Hyperlinks, but they aren't clickable. What can i do to make these export into excel with clickable hyperlinks?
This is what I'm using to export into excel:
DoCmd.OutputTo acOutputQuery, "selectFullReport", acFormatXLSX, "C:\Test.xlsx", True