+- Micro Focus QTP (UFT) Forums (https://www.learnqtp.com/forums)
+-- Forum: Micro Focus UFT (earlier known as QTP) (https://www.learnqtp.com/forums/Forum-Micro-Focus-UFT-earlier-known-as-QTP)
+--- Forum: UFT / QTP Regular Expressions (https://www.learnqtp.com/forums/Forum-UFT-QTP-Regular-Expressions)
+--- Thread: Invalid procedure call or argument (/Thread-Invalid-procedure-call-or-argument)
Invalid procedure call or argument - Uma - 09-10-2011
Hi,
In my Excel sheet I have 3 rows.Up to three rows my script is woking fine with the following for loop
Code:
For intRow = intStartRow to xlWrksht.UsedRange.Rows.Count
.......
NextAfter the 3 rd row it is not coming out and it is igoing into the for loop again and started giving the following error,
Invalid procedure call or argument
Line (166):
Code:
"Browser("name:=.*").Page("title:=.*").WebList("name:=SearchType","location:=0").Select "SearchType"Any help?
Thanks,
Uma
Hi
I have 3 rows in my excel sheet and my script is working for all the 3 rows using the following for loop,
Code:
For intRow = intStartRow to xlWrksht.UsedRange.Rows.Count
...............................
NextAfter I checked the third row,it does not coming out,
it goes inside again and it gives some error,
Invalid procedure call or argument
Why?
Any help?
Thanks,
Uma
Hi,
In my Excel sheet I have 3 rows.Up to three rows my script is woking fine with the following for loop
For intRow = intStartRow to xlWrksht.UsedRange.Rows.Count
.......
Next
After the 3 rd row it is not coming out and it is igoing into the for loop again and started giving the following error,
Invalid procedure call or argument
Code:
Line (166): "Browser("name:=.*").Page("title:=.*").WebList("name:=SearchType","location:=0").Select "SearchType"Any help?
Thanks,
Uma
RE: Invalid procedure call or argument - vIns - 09-11-2011
Hi,
Does this "xlWrksht.UsedRange.Rows.Count" return 3?
RE: Invalid procedure call or argument - Ankesh - 09-12-2011
plz post ur code.
RE: Invalid procedure call or argument - Uma - 09-12-2011
Ankesh,
Thanks for asking,
It is working,I gave 3 for loops according to the worksheet,like this,
Code:
For intRow = intStartRow to xlWrksht.UsedRange.Rows.Count
.......
Next
For intRow = intStartRow to xlWrksht1.UsedRange.Rows.Count
.....
Next
For intRow = intStartRow to xlWrksht2.UsedRange.Rows.Count
......
NextThank you
Uma
RE: Invalid procedure call or argument - Uma - 09-21-2011
Hi,
It is solved,I gave 3 for loops according to its sheet.
For intRow = intStartRow to xlWrksht.UsedRange.Rows.Count
Next
For intRow = intStartRow to xlWrksht1.UsedRange.Rows.Count
Next
......
Thank you
Uma
RE: Invalid procedure call or argument - Uma - 10-09-2011
Hi Ankesh,
It was working ,Now it is started giving same error,
It shows error in the following line
Code:
Browser("name:="&result,"application version:=internet explorer 7").Page("title:=Re.*", "index:=0").WebList("name:= SearchType","html id:=Select1").Select SearchType1Thank you
Uma