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...perlinkaddress

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

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"joel anthony" <[email protected]> wrote in message
news:[email protected]...
>
> 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
>
>
> --
> joel anthony
> ------------------------------------------------------------------------
> joel anthony's Profile: http://www.excelforum.com/member.php...o&userid=33728
> View this thread: http://www.excelforum.com/showthread...hreadid=535076
>

[joel anthony]

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