Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Thread Tools Display Modes
Old 05-20-2009, 04:34 AM
tambal tambal is offline independent hyper link execl & word Windows XP independent hyper link execl & word Office 2003
independent hyper link execl & word
Join Date: May 2009
Posts: 1
tambal is on a distinguished road
Default independent hyper link execl & word

My question relate both excel and word

i want to create "catalog" documnet using word & excel that contain
links to "material" : soundfiles,video,other documents etc...

whenever i press the link the specific documnet will be opened


i want the link to be independent to the storgae hardware i use
Here is an example for what i mean by the word independent :

MY document have links:
link1: c:\lib1\a.wav
link2: c:\lin2\libabcd\c.bmp
link3: etc....

i want a system that will enable me to write some variable of different hardware instead of the c:\

so if i copy the same libraries to a diskonkey,external harddisk which have other logical letter like I:\
G:\ i will still be able to use my catalog documnet

without using a replace command

Plese answer both in offcie and excel(office version office 2003)
Reply With Quote
Old 05-20-2009, 03:07 PM
Bird_FAT's Avatar
Bird_FAT Bird_FAT is offline independent hyper link execl & word independent hyper link execl & word Office 2007
Join Date: Apr 2009
Location: South East
Posts: 271
Bird_FAT is on a distinguished road

You need to use relative references to your files! This is the same for both Word and Excel.

First you need to understand the difference between 'absolute' references and 'relative' references...

If you think about them like references to Cells in Excel:
An ABSOLUTE reference points to an exact cell, and it never moves ($A$1)
A RELATIVE reference points to a cell, but if the formula is dragged around the page, the reference can change (A1 - dragged to the right becomes B1)

This is the same idea with hyperlinks in Documents and Spreadsheets.

What you need to do is:

  • Create a folder where you are going to store the document
  • Inside this folder, create another 'Store' folder - this is where you are going to point your links, and where you must ALWAYS keep the linked files! - if you move the documents, you MUST ALWAYS move the entire document folder WITH the Store folder inside it!
  • Place your linked files inside the folder
  • To create the Hyperlink, simply do the process as before, but then edit the created link and REMOVE all of the path from before the Store folder.
eg: your original Hyperlink is:
C:/My Documents/My Link Files/My Linked Files/audio.mp3

Your finished hyperlink is:
../My Linked Files/audio.mp3

You need to include the '../' at the beginning, as it is needed to indicate that it is a relative path.
Reply With Quote

Thread Tools
Display Modes

Similar Threads
Thread Thread Starter Forum Replies Last Post
independent hyper link execl & word clicking on email link gets request to install outlook denno Outlook 3 05-11-2009 02:11 PM
independent hyper link execl & word Problems when pasting as link in Powerpoint amdrescher PowerPoint 4 04-30-2009 07:36 AM
How to link text from one document to another nospamforyou Word 0 10-09-2008 09:14 AM
Link Bar Duplication redbull2689 Misc 0 06-11-2006 08:39 PM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 03:27 PM.

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd. is not affiliated with Microsoft