export table field with hyperlink

[teel73]

I am trying to export a table that includes a field with a hyperlink. The table exports just fine and with the hyperlink. However, in Excel the hyperlink address isn't there so when I click on it, it doesn't open the link. I can manually edit the cell but I want the export to already include it.

Also, if I open the table, and edit the hyperlink with the actual address, then export the table .. the link opens when I click on it in the cell.

So, either I need to figure out how to create the table with the hyperlink already set to its target.

Any suggestions or do I need to be more clear?

Thanks in advance.

 

[vbaInet]

In the Import/Export wizard, tick the Export data with formatting and Layout option and it will preserve the hyperlink.