Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 79
  • Last Modified:

insert text into HTML select field

I want to enter the text selection for the following select field:
<select name="Payerid" id="Payerid" class="text" name="Payerid">
		<option value="383">Aetna Healthcare</option>
                ...

Open in new window

Using VBA, I know I can use:
      IE.getElementById("Payerid").Value = "383"
but there about 100 options so I don't want to keep track of the values (which are meaningless to me) or changes the website developers make.

So is there a  way to enter the text into the select field?
I tried:
     IE.getElementById("Payerid").Text = "Aetna Healthcare"
but that didn't work.

Thanks
0
thenelson
Asked:
thenelson
  • 3
  • 2
1 Solution
 
IrogSintaCommented:
Maybe try something like this:

    Dim sOption As String
                
    For Each inp In IE.Document.getElementsByTagName("option")
        If inp.innerhtml = "Aetna Healthcare" Then
            sOption = Split(inp.outerhtml, """")(1)
            IE.getElementById("Payerid").Value = sOptionValue
            Exit For
        End If
    Next

Open in new window

Ron
0
 
thenelsonAuthor Commented:
IrogSinta,

Do you mean:
   IE.getElementById("Payerid").Value = sOptionValue
0
 
IrogSintaCommented:
Yes I did.  I'll correct it now.  Did you try that?
0
 
thenelsonAuthor Commented:
not yet
0
 
thenelsonAuthor Commented:
This works but I decided to go another direction.

Thanks
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now