Hyperlinking

[acs68]

Hi all,

when I insert a Hyperlink to a file , e.g H:\MyFile.doc

It inserts the link as the full unc to the file, i.e.
\\serverx\userdata\myfiles\MyFile.doc

Is there a way for it to map to a drive letter and not the unc path ?

Even if I type in the h:\MyFile.doc , it replaces it witht the full unc
path. This will cause problems down the track if the server name changes.

any ideas ?

Adam

 

[jeff]

HI,

Maybe this will help answer your question?? (from excel
help)

An absolute URL contains a full address, including the
protocol, the Web server, and the path and file name.

A relative URL has one or more missing parts. The missing
information is taken from the page that contains the URL.
For example, if the protocol and Web server are missing,
the Web browser uses the protocol and domain, such
as .com, .org, or .edu, of the current page.

It is common for pages in a Web to use relative URLs
containing only a partial path and file name. If the
files are moved to another server, any hyperlinks will
continue to work as long as the relative positions of the
pages remain unchanged. For example, a hyperlink on
Products.htm points to a page named apple.htm in a folder
named Food; if both pages are moved to a folder named
Food on a different server, the URL in the hyperlink will
still be correct.

In a Microsoft Excel workbook, unspecified paths to
hyperlink destination files are by default relative to
the location of the active workbook. You can set a
different base address to use by default so that each
time you create a hyperlink to a file in that location,
you'll only have to specify the file name, not the path,
in the Insert Hyperlink dialog box.

jeff