#1
|
|||
|
|||
Search Word for specific strings and replace with hyperlinks from a list
Hi All!
I have a word document that contains about 1200 citations that need to be hyperlinked to the PDF they cite (there are about 120 PDFs total). I've extracted all of the unique citations (about 1000) into column A of a spreadsheet, as well as the corresponding filenames and and file paths in columns B and C. I currently have an extension for Word (Kutools) that allows me to search for a text string and replace it with a file hyperlink, but you can only enter one string at a time and have to manually look up the file location (this method would take days). If possible, I would like a script that can search the Word document for each of the citation strings in Column A, and replace them with a relative hyperlink. Is something like this possible? |
#2
|
||||
|
||||
Relative hyperlinks is not something Word does well. Have a look at the sticky post in the Word forum...
https://www.msofficeforums.com/word/...nal-files.html If you want a macro to link to citations, upload a sample doc showing your representative input data and some text that needs to be searched.
__________________
Andrew Lockton Chrysalis Design, Melbourne Australia |
#3
|
|||
|
|||
Thanks for the response! I've attached a two sample documents. I've extracted all the citations into column B of the spreadsheet, along with the filename and file path in columns C and D.
I've highlighted the citations that need to be searched and replaced in Sample Citation Document. |
Tags |
hyperlink, search and replace, search string |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Search Multiple Strings and if Present get single word as output | transactions | Excel Programming | 1 | 05-17-2019 11:18 AM |
Flagging Hyperlinks using search & replace? | Ambreville | Word | 9 | 05-09-2019 04:39 PM |
Search Multiple strings and create new word file | subodhgupta | Word | 4 | 05-22-2014 03:34 AM |
Search Multiple strings and create new word sheet | subodhgupta | Word Tables | 1 | 05-20-2014 08:09 AM |
update style of all strings available between two specific strings | vikrantkale | Word | 1 | 03-28-2011 06:13 PM |