Forum Discussion

mesg2anil's avatar
mesg2anil
Regular Contributor
15 years ago

Dropdown list not getting updated while inputting the data from excel

Sub adprty1 Dim iexplore Dim w5 Dim p Dim xlSheet Delay 3000   Set iexplore = Sys.Process("iexplore", 2).Page("http://qaserver/Default.asp").document.frames....
mesg2anil's avatar
mesg2anil
Regular Contributor
15 years ago
Hi Irina,



Thank you for quick reply.

I replaced the codes you suggested, but looks like its not working...

Below is the error message I'm getting...



The combo box item 'In4V' not found. 12:11:48 Normal  



In4V is the value i'm trying to pass through arrStr(3) from excel to application

samething if I do it without using arrStr(3), i.e. manual insertion using below code

'iexplore.Item("cboCertifyingCompany").ClickItem("In4V")



drop-down is getting updated correctly



but if I use the below code

iexplore.Item("cboCertifyingCompany").ClickItem(arrStr(3))          'it is not working :(



Please suggest!!



Regards,

Anil