Invalid procedure call or argument

Invalid procedure call or argument - Printable Version

+- 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 

.......

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
Line (166):

Code:
"Browser("name:=.*").Page("title:=.*").WebList("name:=SearchType","location:=0").Select "SearchType"

Why?
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 

...............................

Next

After 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"

Why?
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 

......

Next

Thank 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 SearchType1

Thank you
Uma