Macro how to add hyperlink to text in document

slaycock · #16 10-10-2017, 01:47 PM

Glad it is sort of working (What went wrong initially - do you know?)

For the 66 books this shouldn't be a problem

In VBA the '_' at the end of a line is a line continuation character so you should be able to create the initial string by extending as follows

Code:

Const LIST_OF_AUTHORITIES    As String = "John, Matthew,Mark , Revelation," _
                                                                   & "Genesis, Exodus , Judges, " _
                                                                   & " Book1, Book2, Book3, Book4, book5, book6,  book7 " _
                                                                   & "Book8, Book9, Book10, Book 11"  etc

The individual lines can be longer but I try to keep within about 80-100 characters. Please make sure that each set of names has a finishing ',' except for the last set.

If this doesn't work for you then just write a paragraph seperated list on an empty page at the end of your document and I write a sub to collect the reference names from there.

The occasional . or ) embedded in your hyperlinks just means I've missed an edge case. I'll add some code to check for that.

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
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
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 for word to add page break and specific text to end of document	pizzaman1	Word VBA	6	11-14-2014 11:25 PM