Hyperlink display

[joel anthony]

Thanks in advance
I want to copy my excel hyperlink column from a sheet into an access
table.
The whole address does not come across and does not function. Any
suggestions would be appreciated.
joel

 

[David McRitchie]

Hi Joel,
Assume you want to extract the hyperlink out of object type hyperlinks
you would be best using a User Defined Function. Function and usage at

http://www.mvps.org/dmcritchie/excel/buildtoc.htm#Hyperlinkaddress

link to Instructions to install are at the top of the that page.

 

[joel anthony]

Dave,
Thank-you for the resource.
much reading ahead!
joel