

The book source, for example, yields fields for Author, Title, Year, City and Publisher.Īs you use material within the body of your paper, you’ll need to add inline citations to properly attribute your material to the original source. Rng.Hyperlinks(1).TextToDisplay = StrDispĮnd SubUnless you can post a copy of the document that evidences any remaining problems, it would be difficult to come up with a solution.The Manage Sources tool pulls in the appropriate fields to fill in for each type of source available. Range:=RngRef, Text:=StrLnk, Preserveformatting:=False If InStr(.Text, Chr(19)) And InStr(RngRef.Text, Chr(20)) Then Please let me know if you need any other infoĭim RngRef As Range, StrLnk As String, StrDisp As String I have attached a doc with examples of both.

In a now-famous address, the former Chairman of the HYPERLINK "" \o "Federal Communications Commission" Federal Communications Commission complained that if The word HYPERLINK appears, preafaced by a double !!, and a \o. Note the |, both in the comment on the right and on the last line on the far left There's an extra "|" added after each comment, as in the following example. The first weird behavior occurs around comments. I'll copy how it appears in plain text here, and try to upload an attachment that shows the behavior and screen shot as well. They now appear with numbers, instead of as boxes, exactly as expected. Thank you so much! I installed and ran the macro, which fixed the footnotes beautifully. If those characters are no longer present, does the word 'Accessed' always appear after the hyperlink? If you could clarify that point, we can make more progress there too. They're not in your latest attachment and the process for repairing the hyperlinks, especially, is affected by whether those characters are still present. The next issue to consider is whether the odd characters that show in the attachment to your first post are still in the document. Dim i As Long, RngRef As Range, StrLnk As StringĪ Range:=RngRefĪ Range:=RngRefĮnd SubFor installation & usage instructions, see:
