Excel macro

Discussion in 'Programming' started by krkbkk, May 9, 2012.

0
  1. #1
    I have an excel file with full or URLs in Column A.

    I need a macro to open all the selected URLs in firefox one by one automatically.

    Any help?

    Thanks.
     
    krkbkk, May 9, 2012 IP
  2. tridosil

    tridosil Peon

    Messages:
    477
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #2
    I'm also trying to find out this solution.
    I have a ms word file with some url.
    I have to open all links one by one in one by one tabs.
    I don't know what will i do. but I have to find out any way .
    I'm sure, Some one will help me about this topic.
     
    tridosil, May 9, 2012 IP
  3. krkbkk

    krkbkk Well-Known Member

    Messages:
    1,458
    Likes Received:
    29
    Best Answers:
    0
    Trophy Points:
    195
    #3
    Finally, I've found out a way to get this done in Excel.

    Macro is here :

    Sub gotourlvariable()

    Do While ActiveCell.Offset(a, 0).Value <> ""

    ActiveWorkbook.FollowHyperlink Address:=ActiveCell.Value
    ActiveCell.Interior.ColorIndex = 36
    ActiveCell.Offset(1, 0).Select
    Loop


    End Sub
     
    krkbkk, May 13, 2012 IP