Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
To retrieve link from exported excel sheet and pass it into script
#1
Not Solved
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
Reply
#2
Not Solved
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
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Pass reference to datatable into function smallsteve 2 1,850 09-28-2017, 09:18 PM
Last Post: smallsteve
  Trying to create List box in excel sheet at Run time with values yes No JACKSPARROW 0 1,573 01-17-2017, 11:05 AM
Last Post: JACKSPARROW
  Can you please help me in QTP DP to pass the variable name anshika.agarwal 1 2,583 09-04-2014, 06:43 PM
Last Post: anshika.agarwal
  Excel and Driver Script shipu 1 3,565 02-27-2014, 09:09 AM
Last Post: supputuri
  Custom sort -Excel Sheet kiran 1 3,658 01-28-2014, 09:23 AM
Last Post: supputuri

Forum Jump:


Users browsing this thread: 1 Guest(s)