Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() 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 |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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" wrote in message ... 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 |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() Dave, Thank-you for the resource. much reading ahead! 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to Display hyperlink addresses that already exist as links to | New Users to Excel | |||
How to hyperlink to an image on a different sheet and display it f | New Users to Excel | |||
Hyperlink to a location on worksheet and display full image. | Excel Discussion (Misc queries) | |||
Hyperlink display text maximum in Excel 2003 | Excel Discussion (Misc queries) | |||
How do I display hyperlink in Excel cell? | Excel Discussion (Misc queries) |