Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Any method to copy the hyperlink address from an Office Object?
Any method to copy the address content only from a hyperlinked Office Object
and paste the same to a cell? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Any method to copy the hyperlink address from an Office Object?
You cannot copy the link address directly through Excel build-in menu . you
need to use VBA code to do that. "Narnimar" wrote: Any method to copy the address content only from a hyperlinked Office Object and paste the same to a cell? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Any method to copy the hyperlink address from an Office Object?
Maybe you could use a userdefined function to extract the hyperlink from the
cells that have them. Option Explicit Function GetURL(Rng As Range) As String Application.Volatile Set Rng = Rng(1) If Rng.Hyperlinks.Count = 0 Then GetURL = "" Else GetURL = Rng.Hyperlinks(1).Address End If End Function So if you had a hyperlink in A1, you could put =getURL(a1) in that adjacent cell. Be aware that if you change the hyperlink, then this formula cell won't change until your workbook calculates. If you're new to macros: Debra Dalgleish has some notes how to implement macros he http://www.contextures.com/xlvba01.html David McRitchie has an intro to macros: http://www.mvps.org/dmcritchie/excel/getstarted.htm Ron de Bruin's intro to macros: http://www.rondebruin.nl/code.htm (General, Regular and Standard modules all describe the same thing.) Short course: Open your workbook. Hit alt-f11 to get to the VBE (where macros/UDF's live) hit ctrl-R to view the project explorer Find your workbook. should look like: VBAProject (yourfilename.xls) right click on the project name Insert, then Module You should see the code window pop up on the right hand side Paste the code in there. Now go back to excel. Into a test cell and type: =getURL(a1) Narnimar wrote: Any method to copy the address content only from a hyperlinked Office Object and paste the same to a cell? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Method Add of object Validation Failed - please help | New Users to Excel | |||
Method Add of object Validation Failed - please help | Excel Worksheet Functions | |||
Object property/method problem | Excel Discussion (Misc queries) | |||
Copy/Paste Hyperlink Address | Excel Discussion (Misc queries) | |||
How can I copy/paste a hyperlink address without the link? | Excel Discussion (Misc queries) |