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.