PC Review


Reply
Thread Tools Rate Thread

Relative File Path

 
 
Jim
Guest
Posts: n/a
 
      22nd May 2005
I have an excel spreadsheet that contains calculations and a Word document
that has a number of link references to it within the text of a report.
Everything works fine and the excel sheets show up in the report as another
page with headers and footers and correct page numbers etc.

The problem occurs when I want to copy the two files to another project
subdirectory and then try to make chnges to both. All the links in the Word
document still refer back to the original excel spreadsheet back in the
first project subdirectory. I have to manually repoint all the links to the
new project subdirectory. Is there any way to cause the link to be to a
relative address, that is make it look for the excel file in the same
directory that contains the Word file? I can only figure out how to tell it
absolute addresses of links

I will also post this in the Excel group..


 
Reply With Quote
 
 
 
 
Shauna Kelly
Guest
Posts: n/a
 
      23rd May 2005
Hi Jim

If you do Alt-F9, you will expose all the field codes in the document. You
can then search and replace the text within the field codes. So the simplest
solution might be to search for the old path name and replace with the new
path name. Alt-F9 toggles between field results and field codes and F9
updates a field.

You can also edit the field codes to use relative paths. But Word sometimes
prefers absolute paths, so test thoroughly.

Hope this helps.

Shauna Kelly. Microsoft MVP.
http://www.shaunakelly.com/word


"Jim" <(E-Mail Removed)> wrote in message
news:Px0ke.1023$(E-Mail Removed)...
>I have an excel spreadsheet that contains calculations and a Word document
> that has a number of link references to it within the text of a report.
> Everything works fine and the excel sheets show up in the report as
> another
> page with headers and footers and correct page numbers etc.
>
> The problem occurs when I want to copy the two files to another project
> subdirectory and then try to make chnges to both. All the links in the
> Word
> document still refer back to the original excel spreadsheet back in the
> first project subdirectory. I have to manually repoint all the links to
> the
> new project subdirectory. Is there any way to cause the link to be to a
> relative address, that is make it look for the excel file in the same
> directory that contains the Word file? I can only figure out how to tell
> it
> absolute addresses of links
>
> I will also post this in the Excel group..
>
>



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to judge whether a path is relative path or absolute path thinktwice Microsoft Windows 2000 CMD Promt 20 7th May 2008 11:06 PM
how can we change absolute path to relative path waseem hijazi via .NET 247 Microsoft ADO .NET 0 15th May 2005 01:38 PM
absolute path to relative path conversion Rizaan Jappie Microsoft C# .NET 7 13th Jan 2005 06:39 PM
why relative hint path but absolute reference path gerry Microsoft Dot NET Framework 1 23rd Sep 2004 09:44 AM
There are any Path or Directory function to convert an absolute pathto a relative path? Ffelagund Microsoft VC .NET 2 8th Mar 2004 08:26 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:05 AM.