Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-26-2022, 02:32 PM
jlive24 jlive24 is offline Search Word for specific strings and replace with hyperlinks from a list Windows 11 Search Word for specific strings and replace with hyperlinks from a list Office 2021
Novice
Search Word for specific strings and replace with hyperlinks from a list
 
Join Date: Jun 2022
Posts: 2
jlive24 is on a distinguished road
Default 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?
Reply With Quote
  #2  
Old 06-26-2022, 07:18 PM
Guessed's Avatar
Guessed Guessed is offline Search Word for specific strings and replace with hyperlinks from a list Windows 10 Search Word for specific strings and replace with hyperlinks from a list Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,932
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

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
Reply With Quote
  #3  
Old 06-26-2022, 08:14 PM
jlive24 jlive24 is offline Search Word for specific strings and replace with hyperlinks from a list Windows 11 Search Word for specific strings and replace with hyperlinks from a list Office 2021
Novice
Search Word for specific strings and replace with hyperlinks from a list
 
Join Date: Jun 2022
Posts: 2
jlive24 is on a distinguished road
Default

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.
Attached Files
File Type: docx Sample Citation Document.docx (19.6 KB, 6 views)
File Type: xlsx Sample Citation Spreadsheet.xlsx (11.3 KB, 6 views)
Reply With Quote
Reply

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
Search Word for specific strings and replace with hyperlinks from a list Flagging Hyperlinks using search & replace? Ambreville Word 9 05-09-2019 04:39 PM
Search Word for specific strings and replace with hyperlinks from a list Search Multiple strings and create new word file subodhgupta Word 4 05-22-2014 03:34 AM
Search Word for specific strings and replace with hyperlinks from a list Search Multiple strings and create new word sheet subodhgupta Word Tables 1 05-20-2014 08:09 AM
Search Word for specific strings and replace with hyperlinks from a list update style of all strings available between two specific strings vikrantkale Word 1 03-28-2011 06:13 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:07 PM.


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