| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pulling Embedded LInk Out of Cell
I have a list of sites (ex-"Running Site") in an excel column that are formatted as links (ie: a browser with a link opens when you click on the cell). I want to write a macro that will pull the links out of the cell and write them to a text file or an adjacent column. How can I do that? I basically just need the line of code that will identify the link that is embedded in the cell. Thanks~ -- bobbabuoy ------------------------------------------------------------------------ bobbabuoy's Profile: http://www.excelforum.com/member.php...o&userid=33491 View this thread: http://www.excelforum.com/showthread...hreadid=532907 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pulling Embedded LInk Out of Cell
If A1 contains a hyperlink then
=hyp2(A1) will display the link Enter this tiny UDF: Function hyp2(r As Range) As String hyp2 = r.Hyperlinks(1).Address End Function -- Gary's Student "bobbabuoy" wrote: I have a list of sites (ex-"Running Site") in an excel column that are formatted as links (ie: a browser with a link opens when you click on the cell). I want to write a macro that will pull the links out of the cell and write them to a text file or an adjacent column. How can I do that? I basically just need the line of code that will identify the link that is embedded in the cell. Thanks~ -- bobbabuoy ------------------------------------------------------------------------ bobbabuoy's Profile: http://www.excelforum.com/member.php...o&userid=33491 View this thread: http://www.excelforum.com/showthread...hreadid=532907 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pulling Embedded LInk Out of Cell
activecell.Hyperlinks(1).Address
"bobbabuoy" wrote: I have a list of sites (ex-"Running Site") in an excel column that are formatted as links (ie: a browser with a link opens when you click on the cell). I want to write a macro that will pull the links out of the cell and write them to a text file or an adjacent column. How can I do that? I basically just need the line of code that will identify the link that is embedded in the cell. Thanks~ -- bobbabuoy ------------------------------------------------------------------------ bobbabuoy's Profile: http://www.excelforum.com/member.php...o&userid=33491 View this thread: http://www.excelforum.com/showthread...hreadid=532907 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Link page header with cell contents | Excel Worksheet Functions | |||
| hyperlink - link one cell to another in a worksheet. how? | Excel Worksheet Functions | |||
| How to link cell for value in another cell of pivot table? | Excel Discussion (Misc queries) | |||
| How do I use a cell value as the filename in an external link? | Excel Discussion (Misc queries) | |||
| How do I use a cell value as the filename in an external link? | Excel Worksheet Functions | |||
Linear Mode
