View Single Post
 
Old 01-29-2019, 04:59 AM
mroatman mroatman is offline Mac OS X Office 2019
Novice
 
Join Date: Jan 2019
Location: Tallinn, Estonia
Posts: 9
mroatman is on a distinguished road
Default URL formatting + a new question

I'm sure I am about to annoy many of you as I have no background in coding or VBA, but I have a problem I'm hoping someone can help me resolve.

I have a 35-page Word document with several hundred embedded links. I need to complete the markdown for this document so that a proprietary Content Management System can read it. For links, the formula is [>URL|TEXT].

For example: Tallinn Botanic Garden appears in the Word document, but I need it to instead read [>http:// botaanikaaed.ee/en|Tallinn Botanic Garden].

To do this manually for hundreds of links is painstaking, so I'm looking for a bit of code that will scan my text for links, extract the URL, then reformat as above.

Is something like this possible?

Thanks in advance for any help.

Last edited by mroatman; 01-29-2019 at 07:40 AM.
Reply With Quote