software

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: www.excelforum.com/member.php...oamp;userid=33728
View this thread: www.excelforum.com/showthread...hreadid=535076Hi 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

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: www.mvps.org/dmcritchie/excel/excel.htm
Search Page: www.mvps.org/dmcritchie/excel/search.htm

quot;joel anthonyquot; gt; wrote in message
...
gt;
gt; Thanks in advance
gt; I want to copy my excel hyperlink column from a sheet into an access
gt; table.
gt; The whole address does not come across and does not function. Any
gt; suggestions would be appreciated.
gt; joel
gt;
gt;
gt; --
gt; joel anthony
gt; ------------------------------------------------------------------------
gt; joel anthony's Profile: www.excelforum.com/member.php...oamp;userid=33728
gt; View this thread: www.excelforum.com/showthread...hreadid=535076
gt;

Dave,
Thank-you for the resource.
much reading ahead!
joel--
joel anthony
------------------------------------------------------------------------
joel anthony's Profile: www.excelforum.com/member.php...oamp;userid=33728
View this thread: www.excelforum.com/showthread...hreadid=535076