Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Invalid procedure call or argument
#1
Solved: 10 Years, 7 Months, 3 Weeks ago
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
Reply
#2
Solved: 10 Years, 7 Months, 3 Weeks ago
Hi,

Does this "xlWrksht.UsedRange.Rows.Count" return 3?
Reply
#3
Solved: 10 Years, 7 Months, 3 Weeks ago
plz post ur code.
Reply
#4
Solved: 10 Years, 7 Months, 3 Weeks ago
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
Reply
#5
Solved: 10 Years, 7 Months, 3 Weeks ago
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
Reply
#6
Solved: 10 Years, 7 Months, 3 Weeks ago
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
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Generate Invalid Values rsk_beckon 1 2,462 01-08-2014, 06:01 PM
Last Post: K Gaurav Varshney

Forum Jump:


Users browsing this thread: 1 Guest(s)