Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.pagelayout
|
|||
|
|||
Links
I plan to email two documents: a word doc and an excel doc. the word doc
has links to the excel document. Do I have to do anything special to keep these links working when I send it by email? Thanks, Jeannine |
#2
Posted to microsoft.public.word.pagelayout
|
|||
|
|||
Links
The links would only work if the path to the Excel file is the same on the
recipients machine as on your machine. They may therefore need a macro such as the following if that is not the case: ' 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 Integer 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 "Jeannine" wrote in message ... I plan to email two documents: a word doc and an excel doc. the word doc has links to the excel document. Do I have to do anything special to keep these links working when I send it by email? Thanks, Jeannine |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Links | Microsoft Word Help | |||
toc with links | Microsoft Word Help | |||
Word2000 changes relative links to absolute links | Page Layout | |||
links | Microsoft Word Help | |||
Removing a group of hypertext links or all hypertext links in a document | Tables |