Convert File Paths to Hyperlinks

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Convert File Paths to Hyperlinks

  1. #1
    New Member
    Join Date
    Mar 2005
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Convert File Paths to Hyperlinks

     
    I have a spreadsheet that contains a column with file paths in it. I would like to run a macro and convert all of them to hyperlinks that will open the htm file they're pointing to. I'd like to be able to convert them all at once.

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Bogota, Colombia
    Posts
    11,959
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    How about using a formula

    =HYPERLINK(A2)

    and double click on the fill handle, and you're done.
    Regards,

    Juan Pablo González
    http://www.juanpg.com

  3. #3
    New Member
    Join Date
    Mar 2005
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Convert File Paths to Hyperlinks

    Can you be a little more specific, I'm very new with excel.

  4. #4
    MrExcel MVP
    Join Date
    May 2002
    Posts
    14,181
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    ******** ******************** ************************************************************************>
    Microsoft Excel - Book2___Running: xl2000 : OS = Windows Windows 2000
    File Edit View Insert Options Tools Data Window Help About
    =

    A
    B
    C
    D
    1
    c:\path\file1.htmc:\path\file1.htm
    2
    c:\path\file1.htmc:\path\file1.htm
    3
    c:\path\file1.htmc:\path\file1.htm
    4
    c:\path\file1.htmc:\path\file1.htm
    5
    c:\path\file1.htmc:\path\file1.htm
    Sheet1

    [HtmlMaker light Ver1.10] To see the formula in the cells just click on the cells hyperlink or click the Name box
    PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.

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
  •  

 

 
DMCA.com