G
Guest
I've unsuccessfully attempted to export a hyperlink field to Excel (2003)
from a table in Access (2003). I used the xfertoexcel macro and the data
type being Hyperlink. In the macro I defined the path with the extention
being .xls so it open automatically in Excel, however it places a ' in each
of the fields at export time, which isn't recognized in Excel. My hope was
that with the hyperlink field in Excel you could just click on it. Thank you
in advance for any and all comments. I did suceed in exporting the same table
as a .htm file that opened and performed correctly.
Maurice
from a table in Access (2003). I used the xfertoexcel macro and the data
type being Hyperlink. In the macro I defined the path with the extention
being .xls so it open automatically in Excel, however it places a ' in each
of the fields at export time, which isn't recognized in Excel. My hope was
that with the hyperlink field in Excel you could just click on it. Thank you
in advance for any and all comments. I did suceed in exporting the same table
as a .htm file that opened and performed correctly.
Maurice