Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Amersfoort, Netherlands
    Posts
    199
    Thanks
    4
    Thanked 0 Times in 0 Posts

    updating linked tables in some word doc by using VBA in Excel

    Hello all,
    I would like to use an Excel sheet to run a macro that will update the paths of all linked tables of all the word documents in a given folder.
    I have seen how to check what the code is of a linked table, but how do I change the path in this code and update the word doc?

    Thanks for your replies.

    Patrick Schouten
    The Netherlands

  2. Subscribe to our Windows Secrets Newsletter - It's Free!

    Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!

    Excel 2013: The Missing Manual

    + Get this BONUS — free!

    Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!

  3. #2
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    3,879
    Thanks
    0
    Thanked 183 Times in 168 Posts
    Hi siflaar,

    To do this from Excel, you have to start Word (if it's not already running), then open each document. From there, it's a matter of using code like that attached to http://lounge.windowssecrets.com/ind...owtopic=670027 to update the link paths. That code shows how you can change the link paths in the links.
    Cheers,

    Paul Edstein
    [MS MVP - Word]

  4. #3
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Amersfoort, Netherlands
    Posts
    199
    Thanks
    4
    Thanked 0 Times in 0 Posts
    Hello Paul,

    Even after searching and reading al lot of posts, I did not find this one.
    So thanks for pointing me to it. It seems in de code is enough information for me to create my own code.

    greetings,
    Patrick Schouten
    The Netherlands

    PS, how do I mark this thead as [solved]?

  5. #4
    New Lounger
    Join Date
    Nov 2013
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hello all! The link that Paul posted no longer works. I need to do a very similar thing - updating the paths of all linked tables in a Word document. I was unsuccessful in searching around the Lounge for the thread. Would Paul, Patrick, or someone else be able to point me to the post? A full post detailing my problem is here. Thanks!

  6. #5
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    3,879
    Thanks
    0
    Thanked 183 Times in 168 Posts
    The thread referred to in that post is now at: http://windowssecrets.com/forums/sho...External-Files
    Cheers,

    Paul Edstein
    [MS MVP - Word]

Tags for this Thread

Posting Permissions

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