Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Word > Word VBA

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 08-19-2016, 08:22 AM
JDHeisenberg JDHeisenberg is offline Windows 10 Office 2013
Novice
 
Join Date: Aug 2016
Posts: 3
JDHeisenberg is on a distinguished road
Default Update source for multiple links to excel document


I have a word document with 20+ links to an excel document. When I go to produce a new report, I copy my word and excel template file and rename. I now need to update the link source to recognize my new excel sheet.

As of now, I have to update the source for each individual 20+ links, is there a way to automate this process? I dabbled in excel macros a few years ago but do not know beyond the basics.

I tried highlighting all the links in the link manager screen then updating the source. This just automatically opens and has me select the source location 20 times.

Thanks
Reply With Quote
  #2  
Old 08-19-2016, 04:23 PM
macropod's Avatar
macropod macropod is online now Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 18,457
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

You could use Find/Replace to change the paths:

Simply press Alt-F9 to expose the field codes in the document, then use Find/Replace to replace the old path/filename with the new one. Note that you'll need to use double backslashes as the separators. Once you've done the Find/Replace, Alt-F9 again the toggle the field code display, then press Ctrl-A, F9 to refresh the links.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to update source excel file with changes made to insserted excel file in OneNote winwell OneNote 1 11-03-2015 12:19 PM
Changing Field Links in a Word Document from one excel file to another Fed77 Word VBA 11 07-08-2015 02:24 AM
How do you update your source docs from a master document? Joyce Word 3 07-12-2013 08:54 AM
no automatic update from external source file Intruder Excel 1 11-08-2012 08:03 PM
Link and change source for multiple tabs from excel to powerpoint excel3 PowerPoint 1 01-19-2012 02:01 AM


All times are GMT -7. The time now is 01:42 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft