IE automation VBA drop down list

  • I am attempting to retrieve data from a website into excel.

    I can get the default 10 datas from a table, but it has a select button for options 25,50,100

    I am trying to select 100, but I can't make it work.

    Would appreciate any input.

    Thanks


  • Hi Serhito,


    Welcome to OzGrid.


    It looks like you're actually trying to get the list and then go two levels below it in the DOM? You can't use getElementsById because it doesn't have an ID.


    I'd just get the dropdown directly rather than trying to go through child objects in the DOM:


    Code
    1. Set List = ieObj.document.getElementsByClassName("earnings_announcements_earnings_table_length")(0)