Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Link Excel Word Current Directory
I have a Word 2007 Doc with multiple links (not embedded) to one Excel
Worksheet. The two have many copies for different uses and users but always appear in a folder together. Is there a quick way to set Links in the Word document to the equivalent of $CurrentDirectory so that I do not have to update a long list of Links every time I copy it to a new location. Managing Trust Centre is not a problem. |
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Link Excel Word Current Directory
See Item 7 in the article at
http://support.microsoft.com/default...en-us%3B159940 The following macro can also be used to update the links: ' Macro created 26/10/01 by Doug Robbins to update links in a document ' Dim alink As Field, linktype As Range, linkfile As Range Dim linklocation As Range, i As Integer, j As Integer, linkcode As Range Dim Message, Title, Default, Newfile Dim counter As Long counter = 0 For Each alink In ActiveDocument.Fields If alink.Type = wdFieldLink Then Set linkcode = alink.Code i = InStr(linkcode, Chr(34)) Set linktype = alink.Code linktype.End = linktype.Start + i j = InStr(Mid(linkcode, i + 1), Chr(34)) Set linklocation = alink.Code linklocation.Start = linklocation.Start + i + j - 1 If counter = 0 Then Set linkfile = alink.Code linkfile.End = linkfile.Start + i + j - 1 linkfile.Start = linkfile.Start + i Message = "Enter the modified path and filename following this Format " & linkfile Title = "Update Link" Default = linkfile Newfile = InputBox(Message, Title, Default) End If linkcode.Text = linktype & Newfile & linklocation counter = counter + 1 End If Next alink -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "WJFinNZ" wrote in message ... I have a Word 2007 Doc with multiple links (not embedded) to one Excel Worksheet. The two have many copies for different uses and users but always appear in a folder together. Is there a quick way to set Links in the Word document to the equivalent of $CurrentDirectory so that I do not have to update a long list of Links every time I copy it to a new location. Managing Trust Centre is not a problem. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Grouping an Excel Field in a Word 2003 Directory Merge | Mailmerge | |||
Word Directory Style Merge from Excel | Mailmerge | |||
How do I create change current directory macro | Microsoft Word Help | |||
How do you convert an excel document into a word directory docume. | Microsoft Word Help | |||
Excel Link: Adding rows in Excel does not add cells in Word | Tables |