Extracting value from a link box
Results 1 to 4 of 4

Thread: Extracting value from a link box
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Jan 2007
    Posts
    53
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Extracting value from a link box

    Hi,
    I have an excel file which has a link box in a particular cell. Now I am writing a macro which requires the value displayed by this link box. The problem is that the value as displayed by the link box is not the content of the cell. So I am perplexed as to how to extract that value from that cell.
    Can anyone help me on this? If required, I can mail you the excel file. You may reply over here or may even mail me at nachiket.pendharkar@mpchitale.com

    Thanx in advance,
    Nachiket Pendharkar

  2. #2
    Board Regular Norie's Avatar
    Join Date
    Apr 2004
    Location
    Stirling, Scotland
    Posts
    75,112
    Post Thanks / Like
    Mentioned
    60 Post(s)
    Tagged
    6 Thread(s)

    Default

    Link box?:o

    Do you mean you have a hyperlink in the cell?
    If posting code please use code tags.

  3. #3
    Board Regular QuietRiot's Avatar
    Join Date
    May 2007
    Location
    Boston
    Posts
    974
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    can you upload your workbook on one of those file upload sites

    email doesn't do any good for me since I'm at work and would rather I not give that out
    -Qu!et Ri0t

  4. #4
    Board Regular
    Join Date
    Jan 2007
    Posts
    53
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    @Norie
    Should I mail you the file? Please mail me your email id so that I can send you the file and you can see what I am trying to say.

    @QuietRiot
    Which site are you referring to? Where do you suggest I should upload it?

    Regards,
    Nachiket Pendharkar

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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