Select a value from a drop down list on the web (HTML) with VBA

[Juan Fonseca]

Kind regards, I am trying to automate a process to upload information from an excel to a web page.

I have already managed to upload all the information looking for the IDs, Classes, Tag, Names as appropriate (searching the page for each section and using .getElementById, .getElementsByTagName, .getElementsByName, etc ... (this part is clear to me)) , but I get to the drop-down list and I don't know how to select one of its options.

Specifically, I want to change that option "Vigente" to "Terminado".


I appreciate who can guide me, thank you very much for your attention.

 

[lrobbo314]

Something like this.

Sub TestDD()
Dim IE As Object: Set IE = CreateObject("InternetExplorer.Application")
Dim dd As Object

With IE
    .navigate "https://www.seleniumeasy.com/test/basic-select-dropdown-demo.html"
    Set dd = .document.getelementbyID("select-demo")
    Debug.Print dd.Children(1).innertext
End With
End Sub

 

[Juan Fonseca]

Your answer was according to my undertanding of the web scrapping knowlage, don't worry, it wasn't neccesary a code example.

Thanks, for your help. This "Children" option apply if i have a class or a tag instead of the ID?.