I created a script to BEGIN to do what I need. This script interacts with the initial form. I can fill out the form and submit, but it errors. Upon further inspection, after a selection is made in the first dropdown field, the form is supposed to refresh with updated dropdown options. With my code, it doesn't allow the form to refresh after the first selection is made. Here is my somewhat-working code:
[pre]set ie = createobject("internetexplorer.application")
Set objShell = CreateObject("WScript.Shell")
ie.navigate "ie.Visible = True
do until ie.readystate = 4 : wscript.sleep 10: loop
IE.Document.getElementsByTagName("select")("Board").Value = "25"
do until ie.readystate = 4 : wscript.sleep 10: loop
IE.Document.getElementsByTagName("select")("County").Value = "11"
IE.Document.getElementsByTagName("select")("RecsPerPage").Value = "50"
For Each btn In IE.Document.getElementsByTagName("input")
If btn.type = "image" Then
btn.Click()
Next
[/pre]
My question is - how do I allow the form to update after the first selection? First selection being:
[pre]
IE.Document.getElementsByTagName("select")("Board").Value = "25"[/pre]
I tried adding this after, but no dice:
[pre]do until ie.readystate = 4 : wscript.sleep 10: loop[/pre]
Thanks in advance
[pre]set ie = createobject("internetexplorer.application")
Set objShell = CreateObject("WScript.Shell")
ie.navigate "ie.Visible = True
do until ie.readystate = 4 : wscript.sleep 10: loop
IE.Document.getElementsByTagName("select")("Board").Value = "25"
do until ie.readystate = 4 : wscript.sleep 10: loop
IE.Document.getElementsByTagName("select")("County").Value = "11"
IE.Document.getElementsByTagName("select")("RecsPerPage").Value = "50"
For Each btn In IE.Document.getElementsByTagName("input")
If btn.type = "image" Then
btn.Click()
Next
[/pre]
My question is - how do I allow the form to update after the first selection? First selection being:
[pre]
IE.Document.getElementsByTagName("select")("Board").Value = "25"[/pre]
I tried adding this after, but no dice:
[pre]do until ie.readystate = 4 : wscript.sleep 10: loop[/pre]
Thanks in advance