Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Jun 2009
    Location
    Hemet CA
    Posts
    310
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi
    I have XP pro with s.p 3 and Office 2007
    I presently have a folder named “Reports” that is located in “Program Files” in this folder I have an Excel workbook along with a few Word documents. The Word documents has links to Excel workbook. My question is I would like to know of a universal directory location for XP, Vista and 7 that I could use to locate my folder too. I do understand I will have to update field locations, that not a problem.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    I'm not sure I understand your question, but

    1. As long as the Word documents and Excel workbook are in the same folder, links between them should work.
    2. You may be able to use macropod's Relative Paths in Word Fields (All).

  3. #3
    3 Star Lounger
    Join Date
    Jun 2009
    Location
    Hemet CA
    Posts
    310
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi HansV
    One of my targets link shows : {LINK Excel.Sheet.8 "C:\\Program Files\\HomInspect\\HomInspect Software Program.xlsb!Client_info!R49C14" "" \a \p \* MERGEFORMAT}
    This refers to program files.
    I’m trying to find a universal destination for XP, Vista and 7, so that no matter what system I may use the links will stay intact.
    any thoughts

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    A subfolder of Program Files is definitely not a good idea, for it is out of bounds under Windows Vista and Windows 7. Please see my previous reply - you can use relative paths, so that it doesn't really matter in which folder the files reside.

  5. #5
    3 Star Lounger
    Join Date
    Jun 2009
    Location
    Hemet CA
    Posts
    310
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thanks HansV
    I appreciate it, I'll try relative paths a try

Posting Permissions

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