Macro to extract URL's from a hyperlink, any thoughts?

Feb 27th, 2002, 09:38 AM

Does anyone know of a macro that will extract a URL out of a hyperlink so that I can paste the URL into a cell? I have thousands of hyperlinks, and I need the URL that is associated with the URL. Thank you...

Taylor in Tennessee

Juan Pablo González · Feb 27th, 2002, 09:40 AM

Sure...(This I assume is from a "real" Hyperlink, not from one resulting of the HYPERLINK formula)

I got this from the inmediate window:

?ActiveCell.Hyperlinks(1).Address
http://www.mrexcel.com/

Feb 27th, 2002, 09:43 AM

I am sorry, I did not understand that answer.

Taylor

Aladin Akyurek · Feb 27th, 2002, 09:44 AM

See also:

http://mrexcel.com/board/viewtopic.p...ic=200&forum=2

Feb 27th, 2002, 09:40 AM	#2
Juan Pablo González MrExcel MVP Join Date: Feb 2002 Location: Bogota, Colombia Posts: 11,927	Sure...(This I assume is from a "real" Hyperlink, not from one resulting of the HYPERLINK formula) I got this from the inmediate window: ?ActiveCell.Hyperlinks(1).Address http://www.mrexcel.com/ __________________ Regards, Juan Pablo González http://www.juanpg.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 27th, 2002, 09:38 AM	#1
Guest Posts: n/a	Does anyone know of a macro that will extract a URL out of a hyperlink so that I can paste the URL into a cell? I have thousands of hyperlinks, and I need the URL that is associated with the URL. Thank you... Taylor in Tennessee

Feb 27th, 2002, 09:43 AM	#3
Guest Posts: n/a	I am sorry, I did not understand that answer. Taylor

Feb 27th, 2002, 09:44 AM	#4
Aladin Akyurek MrExcel MVP Join Date: Feb 2002 Location: The Hague Posts: 50,314	See also: http://mrexcel.com/board/viewtopic.p...ic=200&forum=2