Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 7th 05, 08:23 PM
Chris Ince
 
Posts: n/a
Default Excel Hyperlink Base Directory

Hi,

I am distributing a workbook which has a set of accompanying notes (help
file) as a Word Document. The Word doc is linked to various cells in the
worksheet by a series of hyperlinks.

The problem is that I do not know where end-users will save the worksheet
and its accompanying files. I can suggest, but every user will have a
different user name depending upon their organisation etc. eg My
Documents\user\Log Book (for "user" insert any combination of letters/number!)

I would like to just force Excel to locate the Word doc in the same
directory as the active worksheet (as this is where it will be) but to no
avail so far.

Am using Macros already, so VBA solution would not be a problem.

Many thanks,
Chris

  #2   Report Post  
Old November 7th 05, 08:46 PM
Elkar
 
Posts: n/a
Default Excel Hyperlink Base Directory

Don't include a path with the filename in the link. Just use the file name.
Windows will then assume that the path of the destination file is the same as
the open file.

HTH,
Elkar

"Chris Ince" wrote:

Hi,

I am distributing a workbook which has a set of accompanying notes (help
file) as a Word Document. The Word doc is linked to various cells in the
worksheet by a series of hyperlinks.

The problem is that I do not know where end-users will save the worksheet
and its accompanying files. I can suggest, but every user will have a
different user name depending upon their organisation etc. eg My
Documents\user\Log Book (for "user" insert any combination of letters/number!)

I would like to just force Excel to locate the Word doc in the same
directory as the active worksheet (as this is where it will be) but to no
avail so far.

Am using Macros already, so VBA solution would not be a problem.

Many thanks,
Chris

  #3   Report Post  
Old November 7th 05, 08:52 PM
Chris Ince
 
Posts: n/a
Default Excel Hyperlink Base Directory

Yes, thank you, have just figured it out! Have converted them all to use
HYPERLINK formula rather than "Insert HYperlinks". Works like a dream now.

Shows the problems of a long day and trying to be too complicated.

Thanks again
Chris

"Elkar" wrote:

Don't include a path with the filename in the link. Just use the file name.
Windows will then assume that the path of the destination file is the same as
the open file.

HTH,
Elkar

"Chris Ince" wrote:

Hi,

I am distributing a workbook which has a set of accompanying notes (help
file) as a Word Document. The Word doc is linked to various cells in the
worksheet by a series of hyperlinks.

The problem is that I do not know where end-users will save the worksheet
and its accompanying files. I can suggest, but every user will have a
different user name depending upon their organisation etc. eg My
Documents\user\Log Book (for "user" insert any combination of letters/number!)

I would like to just force Excel to locate the Word doc in the same
directory as the active worksheet (as this is where it will be) but to no
avail so far.

Am using Macros already, so VBA solution would not be a problem.

Many thanks,
Chris



Reply
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
Slow opening directory structure in Excel 2002 Nyte Excel Discussion (Misc queries) 0 August 4th 05 04:44 PM
Excel email address hyperlink does not update Michael Excel Discussion (Misc queries) 1 August 2nd 05 02:36 PM
Hyperlink from Internet Explorer to Excel Ian West Excel Discussion (Misc queries) 0 July 20th 05 02:25 PM
How do I break a hyperlink in an Excel document? Fulchp47 Excel Discussion (Misc queries) 3 May 10th 05 03:40 PM
Excel should let hyperlink of PDF jump to a specific page like IE. Kenn Tan Excel Discussion (Misc queries) 2 April 18th 05 09:23 AM


All times are GMT +1. The time now is 03:12 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017