copy hyperlink to clipboard

[Spencer.Sadkin]

From excel I am trying to copy a hyperlink to the clipboard as
hypertext. For example, if i have a link in microsoft outlook and i
copy that link and paste it into the body of another email the link is
still intact. What I want to do is set the active path of the current
workbook as hypertext so that i can then go copy it into word,
outlook, lotus etc.

Thanks in advance.

 

[Spencer.Sadkin]

From excel I am trying to copy a hyperlink to the clipboard as
hypertext.  For example, if i have a link in microsoft outlook and i
copy that link and paste it into the body of another email the link is
still intact. What I want to do is set the active path of the current
workbook as hypertext so that i can then go copy it into word,
outlook, lotus etc.

Thanks in advance.

if anyone can do this without using an external app thats great,
otherwise i figured out how to do it using word. launch word drop a
hyperlink, select all, copy and voila