getting the path out of a hyperlink

[James]

I need to extract the path from a hyperlink in a cell. Any ideas how to
do this?

 

[Frank Kabel]

Hi
see the following site for some code:
http://www.mvps.org/dmcritchie/excel/buildtoc.htm
(in the middle of this page)