TransferSpreadsheet and Hyperlink field

M

MikeT

Hi,

I have a query that includes a hyperlink column. If I open the query, and
export to Excel, making sure to click the "Save Formatted", the resulting
spreadsheet column is a hyperlink.

I'd like to automate this using DoCmd.TransferSpreadsheet, but I can't
figure out how to preserve the hyperlink in the spreadsheet - the query
exports fine, but the resulting spreadsheet column is just plain text. Is
there a switch or parameter on TransferSpreadsheet that specifies the same as
"Save Formatted"?

Thanks!
 
Top