Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Jun 2011
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Linking excel data to Word document so links survive file name change

    Below is a post from 2009 I found earlier today when searching the above title. The link in the answer provided by macropod no longer is active. Could anyone answer this question as it is the same situation I am working on currently with a template I've create. I would love to work through the macro. I have also attached a link to the site where I found the posts today.

    http://www.officekb.com/Uwe/Forum.as...vive-file-name

    BRC - 17 Dec 2009 06:33 GMT
    If I am in the wrong forum to post this question please let me know.
    My problem is related to linking data in an excel spreadsheet to a
    Word docment in the same folder. Here is situation: each job has a
    folder [job1 job2 job3 etc.], each job folder has at least 2 files a
    spreadsheet and 1 report document. so in folder job1 there will be
    job1.doc and job1.xls. I am trying to develope templates for these 2
    files that will maintain the link. So when we start job4 we can create
    a new folder (job4) and start new files (job4.xls and job4.doc) that
    are linked. I have searched a lot and found some references to
    relative paths vs absolute paths but i couldn't really understand
    them. If anyone has had any experience or can direct me to where i
    might get some more info it would be greatly appreciated Thanks in
    advance.

    Reply to this Message
    [Scroll to Parent Message] [Open Message Tree] macropod - 17 Dec 2009 08:23 GMT
    Hi BRC,

    For what you want, a macro will be needed. That's because links from Word to Excel workbooks use LINK fields and you can't code
    those in a way that allows for relative paths.

    For a macro to implement relative paths in Word, check out the solution I've posted at:
    http://lounge.windowssecrets.com/ind...owtopic=670027

  2. #2
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts
    I think it must be one of these, but I'm not sure which one:

    Relative Paths in Word Fields (All)

    Relative Path Reference for Excel file links (Word 2000)

  3. #3
    New Lounger
    Join Date
    Jun 2011
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts
    The second link you provided had the macro but the link is still broken. Any other thoughts?

    Relative Path Reference for Excel file links (Word 2000)

    Thanks for your help!

  4. #4
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts
    Perhaps you should try the newer thread -- look for ZIP file attachments -- unless you are running a very old version of Word incompatible with the newer code.

    (All links to lounge.windowssecrets.com have stopped working. There used to be a way to rewrite post numbers on that server to redirect to the new server, but since that server is down, the trick no longer works.)
    Last edited by jscher2000; 2011-06-21 at 13:17. Reason: Added note.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •