Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-10-2017, 09:14 AM
slaycock slaycock is offline Macro how to add hyperlink to text in document Windows 7 64bit Macro how to add hyperlink to text in document Office 2013
Expert
 
Join Date: Sep 2013
Posts: 255
slaycock is on a distinguished road
Default

When you are developing skills in a language it sometimes quite interesting to have to solve problems over which you have no control or influence (and which are not made up examples out of a text book).



I could spend my time playing Soduku but your problem was much more interesting.

You may get some false or failed hits. This will be where the references don't conform to the rules derived from the reference texts.

Its easy to find the stem of a reference (e.g. John 1:1) but then defining what happens after that depends on your consistency.

The search actually returns 1 more character than the stem reference e.g. 'John 1:1-' and we use the last character to determine what we need to do next.

Last character of found text is
;.) or space then a complete reference has been found
- then we need to find ending verse and assume a following abbreviated reference
, then an abbreviated reference is next

Once you've devined these rules its just a case of encoding the logic (without getting youself in a tangle) whilst avoiding words little foibles.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro how to add hyperlink to text in document How to embed hyperlink to another document into an ActiveX Control Text Box kenboy21 Word VBA 3 02-24-2017 09:41 PM
Macro (or something) to run Spell Check within rich text content boxes in lock document NMBELL Word 8 12-21-2015 04:09 PM
Macro how to add hyperlink to text in document Moving from hyperlink to hyperlink in a document Bengt Word VBA 2 12-21-2015 12:42 AM
Hyperlink: open the document only once, quit & reopen PP, hyperlink doesnt work anymore quanghuynguyenhua PowerPoint 0 10-10-2015 06:17 PM
Macro how to add hyperlink to text in document Macro for word to add page break and specific text to end of document pizzaman1 Word VBA 6 11-14-2014 11:25 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:59 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft