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

[supputuri]

Hi Nagu,

i could not why you are uploading the links to excel from app and again using the same data.

If you don't mind pls provide your exact requirement (Test Step) that might make the question crystal clear.

1) Anyhow use "trim" while getting the data from excel sheet and from App.
2) Always a good code should have the else part for each if. Please make the chage accordingly.

Let me know ur req and any more help.

Thanks,
QTPKing