extract url from link in column

dhx10000

Board Regular
Joined
Jul 11, 2005
Messages
144
Hi,

I have an excel sheet that contains a column that is a hyperlink. For example, a value may be 'Benefits Document, then when you click on it, it will take you to a URL like 'http://myHumanResourcesServer/directory/Beneifts/benefits.doc'. Is there anyway I can extract this URL? I have another application in which I need to get the filename of each of these documents located at the end of the URL's

thanks,

dhx
 

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().

Joe Was

MrExcel MVP
Joined
Feb 19, 2002
Messages
7,539
Sub HlinksA()
'List all of the selected hyperlinks properties!
'Note: Select a cell next to the H-Link & use the cursor to slide into its cell.
'Then run this code to show that links properties!

Dim hyp As Hyperlink

Set hyp = Selection.Hyperlinks(1)
MsgBox "Address ==> " & hyp.Address & vbCr & _
"Name ==> " & hyp.Name & vbCr & _
"Parent ==> " & hyp.Parent & vbCr & _
"Creator ==> " & hyp.Creator & vbCr & _
"Text ==> " & hyp.TextToDisplay & vbCr & _
"Application ==> " & hyp.Application.Value

End Sub
 

dhx10000

Board Regular
Joined
Jul 11, 2005
Messages
144
Sub HlinksA()
'List all of the selected hyperlinks properties!
'Note: Select a cell next to the H-Link & use the cursor to slide into its cell.
'Then run this code to show that links properties!

Dim hyp As Hyperlink

Set hyp = Selection.Hyperlinks(1)
MsgBox "Address ==> " & hyp.Address & vbCr & _
"Name ==> " & hyp.Name & vbCr & _
"Parent ==> " & hyp.Parent & vbCr & _
"Creator ==> " & hyp.Creator & vbCr & _
"Text ==> " & hyp.TextToDisplay & vbCr & _
"Application ==> " & hyp.Application.Value

End Sub

thank you very much, this worked great!!!
 

Forum statistics

Threads
1,137,367
Messages
5,681,075
Members
419,950
Latest member
BeckiJae

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top