S
SMT
I am using the following code to export my access table to excel. The problem
I have is the hyperlinked fields show up like -
'www.brinkmann.com#http://www.brinkmann.com#. I would just like to see
www.brinkmann.com. Can anyone help?
Private Sub Command26_Click()
DoCmd.TransferSpreadsheet acExport, _
acSpreadsheetTypeExcel9, "Companiesqry", _
"c:\companies3.xls", , "Companies1"
Application.FollowHyperlink "c:\companies3.xls"
End Sub
I notice if I use a macro and OutputTo an excel file the hyperlinks seem to
come over properly, however I need to run some macros upon opening and I have
that working properely in the companies3.xls its just the hyperlink displays
with the #http://www.brinkmann.com#.
I have is the hyperlinked fields show up like -
'www.brinkmann.com#http://www.brinkmann.com#. I would just like to see
www.brinkmann.com. Can anyone help?
Private Sub Command26_Click()
DoCmd.TransferSpreadsheet acExport, _
acSpreadsheetTypeExcel9, "Companiesqry", _
"c:\companies3.xls", , "Companies1"
Application.FollowHyperlink "c:\companies3.xls"
End Sub
I notice if I use a macro and OutputTo an excel file the hyperlinks seem to
come over properly, however I need to run some macros upon opening and I have
that working properely in the companies3.xls its just the hyperlink displays
with the #http://www.brinkmann.com#.