Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
update links in Word from Excel
Dear experts,
I have many, many Word documents where some fileds are linked to cells on an Excel worksheet. Unfortunately I need to change the path of the Excel worksheet and just realized that all links will break!!!! Is there an easy way to replace the path of the Excel worksheet in the Word documents without having to do it manually (4/5 links per document.... 200 documents...) Many thanks in advance for your precious help. Kind regards, Valeria |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
update links in Word from Excel
Hi Valeria,
Check out my Field Link Updater, at: http://lounge.windowssecrets.com/ind...st=20&p=261488 It's fairly old and not coded to word with Office 2007 file formats, but should otherwise do the job. A few mods would get it working for the Office 2007 file formats too. More generally, though, you might find it useful to embed a macro into the relevant Word documents to automatically update the file paths. This is useful if the files are liable to being moved around but always have a fixed relative path between them. To see how, check out the solution I've posted at: http://lounge.windowssecrets.com/ind...owtopic=670027 -- Cheers macropod [Microsoft MVP - Word] "Valeria" wrote in message ... Dear experts, I have many, many Word documents where some fileds are linked to cells on an Excel worksheet. Unfortunately I need to change the path of the Excel worksheet and just realized that all links will break!!!! Is there an easy way to replace the path of the Excel worksheet in the Word documents without having to do it manually (4/5 links per document.... 200 documents...) Many thanks in advance for your precious help. Kind regards, Valeria |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Word 2007 - field "Update automatic links at open" does not work | Excel Discussion (Misc queries) | |||
Suppress Update Links dialog AND don't update links | Excel Programming | |||
Update Excel links in Word | Excel Discussion (Misc queries) | |||
Excel 2003 - Update or Don't Update Links Problem | Excel Programming | |||
Don't update excel links | Excel Worksheet Functions |