Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Louisville, Kentucky, USA
    Posts
    605
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Hyperlinks (Excel 2000)

    Good Morning Everyone!

    Got a new one for everyone...thought I could get this one myself....thought actually I almost had it....but I was wrong!

    In cell X3 is a file name: srs20041606rj
    In celll X4 is a file name: map20041706rj

    in other words everything in Column "X" is a file name

    I would like each file name to be HYPERLINKS

    I've tried putting HYPERLINK("[T:All_NHSOperator]X3") in AA3 and AA4, among other things, but they didn't work .

    Does this need to be coded or am I missing something simple. I know I can right click, select Hyperlink, browse for file, etc. but this would mean it would have to be done by the user each and every time, I don't want the user to have to do this.......can this be accomplished without user interface?

    Thanks once again in advance.


    p.s. if need be, I can put the path (T:All_NHSOperator) in AA and do something like =AA & "" & X3 in cell AB which would give the entire path and file name for the hyperlink
    Roberta Price <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Hyperlinks (Excel 2000)

    The target of the hyperlink is a string; you can concatenate it from different parts. Don't forget to put = before the formula.

    This should work:

    =HYPERLINK("T:All_NHSOperator" & X3)

    Note that there are no brackets [ ] around the path.

    Or, with the text T:All_NHSOperator in cell AA1:

    =HYPERLINK($AA$1 & "" & X3)

    The $ characters make AA1 into an absolute reference that will not change when you copy the formula to X4, X5 etc.

  3. #3
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Louisville, Kentucky, USA
    Posts
    605
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hyperlinks (Excel 2000)

    Thanks Hans,

    It was the "Hyperlink" I was missing.

    Much appreciated!
    Roberta Price <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •