Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
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
Novice
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

but...

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
  #2  
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
Expert
 
Join Date: Apr 2009
Location: South East
Posts: 271
Bird_FAT is on a distinguished road
Default

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
Reply

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.
MSOfficeForums.com is not affiliated with Microsoft