Hi, I'm not really a programmer, but I've found VBA to be useful in many areas of my work. But right now I'm a bit stuck. I need a way to search through documents and extract hypertext URLs as HTML code so I can cut and paste into a web CMS. I believe it can be done. Here's an example of what I want to achieve:

I want to turn:
Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Quisque a.

Into:
Lorem ipsum dolor sit amet, <a href="#">consectetuer adipiscing</a> elit. Quisque a.

Does anyone know how to perform this operation? Really appreciate any help.