Relative links between word doc and excel documents

[ActionEstate]

Hi and thanks for reading.

I have a very, very simple need and I'm sure there HAS to be an answer to
this.

I have a directory which has a subdirectory for each job I do. For
instance...
MyCompany\
MyCompany\Job1\
MyCompany\Job2\

Each Job has some information in which gets repeatedly used by many files
inside of the each subdirectory... For instance Job Name, Job Date, Job
Manager get used in many files for that job... I have a contract.doc per job
(per directory), I have a letter.doc that gets written for each job that
start's off "Dear [Job Manager]),.. actually I have a ton of files inside of
each job which share the information. Most of these are static documents
with only these field values changing. So I thought it would be nice to have
a file named jobinfo.xls in which A1 cell has the JOBNAME, A2 cell has the
JOB DATE, A3 Cell has the Job Manager and so on... That way I could simply
create references inside the contract or letter that references the
"relative" file ./jobinfo.xls

That way, for each new job, I would simply copy and paste job2 to job3, and
then go inside of job3/info.xls and edit the information so that
job3/contract.doc and job3/letter.doc would reflect the correct job's
information.

However, it appears that word/excel links only reference absolute path
info... Is there something I can do to make it look at a relative path?
(I.e. look inside of it's current direcotory for the filename jobinfo.xls)?

This seems so simply and as a lifelong develeop (Not in VB) I KNOW THIS HAS
TO HAVE BEEN SOLVED BEFORE ME

I appreciate taking the time to read this.
Ron

 

[macropod]

Hi ActionEstate,

To see how to implement relative paths in Word, check out the solution I've posted at:
http://www.wopr.com/index.php?showtopic=670027
For links to Excel, vba is needed, but the link includes the necessary code.