Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-07-2011, 07:50 AM
spheon spheon is offline Embedded links Windows 7 32bit Embedded links Office 2007
Novice
Embedded links
 
Join Date: May 2011
Posts: 3
spheon is on a distinguished road
Default Embedded links

Hi Everyone



I have created quite a complicated word template report that links to an excel spreadsheet in many places and therefore has over 75 links to the one spreadsheet.

As this document is a template for many projects I want to copy the word document along with the spreadsheet to many folders (networked) however have realised I have to update the links as the word document remembers the links' original path as opposed to the folder its sat within.

The excel document will alway be in the same folder as the word document...is there any way of forcing it to not have the full path as the embedded link but just the folder its within otherwise its taking me 20mins to laboriously update each link and again when I have to use it for another project

thanks in anticipation...I so hope this can be done...

Sph
Reply With Quote
  #2  
Old 06-07-2011, 04:11 PM
macropod's Avatar
macropod macropod is offline Embedded links Windows 7 32bit Embedded links Office 2007
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Hi spheon,

For a macro to automatically update the links, check out the solution I've posted at:
http://windowssecrets.com/forums/sho...External-Files
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Embedded links Linking an image that is not embedded charismarl Word 1 02-25-2011 01:58 AM
Display the properties of an embedded image tmazzotta PowerPoint 0 02-18-2011 05:41 PM
Embedded links Embedded Excel functionality? markg2 Word 1 01-13-2011 02:17 PM
Embedded links Saving Embedded Videos to a PowerPoint ryanb PowerPoint 1 11-23-2010 10:11 AM
Embedded in invitation? admin99 Outlook 0 08-28-2010 05:34 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:05 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