+ Reply to Thread
Results 1 to 3 of 3

Web Page Hyperlinks/How do you make a list URL's active?

  1. #1
    Registered User
    Join Date
    06-19-2005
    Posts
    49

    Web Page Hyperlinks/How do you make a list URL's active?

    Web Page Hyperlinks/How do you make a list URL's active?

    I have a whole list of many URL's in Excel and I would like to make them active links so that when you press on them, you go to their respective web page. I can do each one, one by one, by pressing F2 on their respective cell and then pressing enter . . this makes them active links, but its way too slow, I could never do all of them (some pages have 15,000 links). Is there some sort of switch to make all of my inactive URL's . . . active links at one time?

  2. #2
    Ron de Bruin
    Guest

    Re: Web Page Hyperlinks/How do you make a list URL's active?

    You can try this with the url in A

    Sub test()
    For Each myCell In Columns("A").Cells.SpecialCells(xlCellTypeConstants)
    ActiveSheet.Hyperlinks.Add Anchor:=myCell, _
    Address:=myCell.Value, TextToDisplay:=myCell.Value
    Next
    End Sub


    If they start with ww you can use this
    Address:="http://" & myCell.Value, TextToDisplay:=myCell.Value



    --
    Regards Ron de Bruin
    http://www.rondebruin.nl


    "pglufkin" <pglufkin.1qw3ia_1119211502.5174@excelforum-nospam.com> wrote in message
    news:pglufkin.1qw3ia_1119211502.5174@excelforum-nospam.com...
    >
    > Web Page Hyperlinks/How do you make a list URL's active?
    >
    > I have a whole list of many URL's in Excel and I would like to make
    > them active links so that when you press on them, you go to their
    > respective web page. I can do each one, one by one, by pressing F2 on
    > their respective cell and then pressing enter . . this makes them
    > active links, but its way too slow, I could never do all of them (some
    > pages have 15,000 links). Is there some sort of switch to make all of
    > my inactive URL's . . . active links at one time?
    >
    >
    > --
    > pglufkin
    > ------------------------------------------------------------------------
    > pglufkin's Profile: http://www.excelforum.com/member.php...o&userid=24443
    > View this thread: http://www.excelforum.com/showthread...hreadid=380418
    >




  3. #3
    David McRitchie
    Guest

    Re: Web Page Hyperlinks/How do you make a list URL's active?

    Possibly they are not links because they have spaces or a
    non breaking space character (&nbsp, or CHAR(160).
    You might try the TRIMALL Macro if Ron's solution doesn't
    work, or include the substitutions and TRIM within his macro.
    ---
    HTH,
    David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
    My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
    Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

    "Ron de Bruin" <rondebruin@kabelfoon.nl> wrote in message news:O%23SRb9QdFHA.3864@TK2MSFTNGP10.phx.gbl...
    > You can try this with the url in A
    >
    > Sub test()
    > For Each myCell In Columns("A").Cells.SpecialCells(xlCellTypeConstants)
    > ActiveSheet.Hyperlinks.Add Anchor:=myCell, _
    > Address:=myCell.Value, TextToDisplay:=myCell.Value
    > Next
    > End Sub
    >
    >
    > If they start with ww you can use this
    > Address:="http://" & myCell.Value, TextToDisplay:=myCell.Value
    >
    >
    >
    > --
    > Regards Ron de Bruin
    > http://www.rondebruin.nl
    >
    >
    > "pglufkin" <pglufkin.1qw3ia_1119211502.5174@excelforum-nospam.com> wrote in message
    > news:pglufkin.1qw3ia_1119211502.5174@excelforum-nospam.com...
    > >
    > > Web Page Hyperlinks/How do you make a list URL's active?
    > >
    > > I have a whole list of many URL's in Excel and I would like to make
    > > them active links so that when you press on them, you go to their
    > > respective web page. I can do each one, one by one, by pressing F2 on
    > > their respective cell and then pressing enter . . this makes them
    > > active links, but its way too slow, I could never do all of them (some
    > > pages have 15,000 links). Is there some sort of switch to make all of
    > > my inactive URL's . . . active links at one time?
    > >
    > >
    > > --
    > > pglufkin
    > > ------------------------------------------------------------------------
    > > pglufkin's Profile: http://www.excelforum.com/member.php...o&userid=24443
    > > View this thread: http://www.excelforum.com/showthread...hreadid=380418
    > >

    >
    >




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1