I am trying to create a glossary that contains links to web pages - and I would like to be able to do it automatically.
I have tried to use David Fountain's Excel/Macro method but find that the macros do not recognise a URL and convert it to text - not the effect I am after.
I have also used Yasu Imao's glossaryXMLconvertor with good effect but find that the resultant XML file has to be manually edited to included 'tags' recognisable by XML to make a URL appear in the definition.
Currently our definitions look like this
By manually adding the red text, then completing the definition with some annotation
<DEFINITION><a href="http://www.1st4sport.com/" target="_blank">Click here</a> to access the Site Coachwise 1st4sport is your one-stop shop for sports coaching training and physical education resources.</DEFINITION>
The comleted definition appears with a clickable link and an annotation.
Whilst I have the patience to manually edit short glossaries the staff who will be preparing these have not and it really is very fiddly - is there an easier way to do this.