LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default ~ ~ ~ Its All Relative???

I would like to accomplish this same task as posted 11 months ago (end files
on a CD and links to each file) . (Using Word & Excel 2007)

I know the answer is to create "relative" file paths
however..............HOW do I create relative path names? When they are on
the CD in a folder the main sheet needs to link to each file.

Word or Excel to accomplish this?


Thank you

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~


David Biddulph" wrote:

Is your hyperlink to a relative address, or an absolute address? If it is
a relative address, then you should be OK if all your files are being copied
onto the same CD with the same relative folder structure as you've got where
you're creating them.
--
David Biddulph

"Jattas" wrote in message
...
I have to archive media clippings for my company. I have a list with
hyperlinks to the source files (JPG's, PDF's, ZIP's etc.)

I have different folders for all the source files (according to date) and
want the end-user to have access to those files with a simple click in
Excel.

The end-product will be on a CD. As I don't know what their CD drive
letter
will be, how can I be certain that the link will guide them to the
corresponding file?


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
What relative row I'm in? fedude Excel Worksheet Functions 3 March 10th 08 02:01 PM
relative reference Swannybuck Excel Discussion (Misc queries) 1 July 26th 06 09:28 PM
Relative references GARY Excel Discussion (Misc queries) 1 June 16th 06 09:23 PM
Relative reference Lakebum Excel Worksheet Functions 2 December 28th 04 05:57 PM
Relative values and NAME beowulf Excel Worksheet Functions 1 December 27th 04 10:51 AM


All times are GMT +1. The time now is 10:35 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"