To retrieve link from exported excel sheet and pass it into script

[Nagu]

Hi

In my application data will be changing so we are exporting the datas from application to excel and later we are using it has input so in this case scripts will not fail.

I was doing something like this:

Will export the links and later take the same links as input:

I used code something like this

Code:

Rowcount =osheet.usedrange.rows.count
msgbox Rowcount

For y=3 to Rowcount
    val=osheet.cells(y,11).Value
msgbox val
        If (val="LA") Then
            msgbox val
Obj.Link("innertext:="&val).Click
            Exit For
        End If        
Next

But its not working what might be wrong here..


Any help would be appreciated