1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Scrapebox exports to Excel..Clickable links

Discussion in 'Black Hat SEO Tools' started by lucabrasi, Mar 20, 2011.

?

Problematic Microsoft products.

  1. MS software is the best of all possible software

    0 vote(s)
    0.0%
  2. MS software is not the problem, dumb operators are

    0 vote(s)
    0.0%
  3. MS has really lost its leadership position in programming

    0 vote(s)
    0.0%
  4. MS hasn't made useful software since XP and Office 2003

    0 vote(s)
    0.0%
Multiple votes are allowed.
  1. lucabrasi

    lucabrasi Regular Member

    Joined:
    Mar 22, 2010
    Messages:
    337
    Likes Received:
    17
    Occupation:
    Layed off from real job but working at a survival
    Location:
    Pacific Northwest, Oregon Washington border
    Home Page:
    Is there any efficient way to make all the links in a Scrapebox export to Excel clickable.

    So far I have been selecting the cell, pushing the space bar, and then moving on to the next cell.

    That is fine for a couple of links. But, I have a Scrapebox number of links. I need a way to make over a thousand PR links clickable.

    I use Excel 2007.

    Thank you for your consideration.
     
  2. blackhatdavid

    blackhatdavid Regular Member

    Joined:
    Nov 5, 2009
    Messages:
    296
    Likes Received:
    106
    Input the following code into a macro. Select the cells you want to convert to hyperlinks and run the macro.

    Code:
    Sub HyperAdd()
    ' 
    ' Converts each text hyperlink selected into a working hyperlink
    '
        For Each xCell In Selection
            ActiveSheet.Hyperlinks.Add Anchor:=xCell, Address:=xCell.Formula
        Next xCell
    '    
    '
    End Sub
     
    • Thanks Thanks x 1
  3. Sup..

    Sup.. Newbie

    Joined:
    Feb 23, 2011
    Messages:
    18
    Likes Received:
    3
    Or from scrapebox export list as .html. Then in excel open the .html file. It leave the table but the links are clickable.
     
    • Thanks Thanks x 1
  4. lucabrasi

    lucabrasi Regular Member

    Joined:
    Mar 22, 2010
    Messages:
    337
    Likes Received:
    17
    Occupation:
    Layed off from real job but working at a survival
    Location:
    Pacific Northwest, Oregon Washington border
    Home Page:
    Thanks for the help. As soon as I figure out how to unhide a sheet I think this will work. Saving as HTML works too, but I need to edit it.
    Either way, you both answered my question and I thank you.

    I am amazed at the answers I get on this forum. I ask a question about making links clickable in an Excel SS in a blackhat marketing forum and I have two workable answers in less than an hour or so. God only knows how much money Microsoft has, but they can't even pay people to do the job this well.
    Awesome.