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, "selectFullRepo rt", acFormatXLSX, "C:\Test.xl sx", True
This is what I'm using to export into excel:
DoCmd.OutputTo acOutputQuery, "selectFullRepo rt", acFormatXLSX, "C:\Test.xl sx", True
Comment