VBA Extract selected dropdown innertext from webpage

Question

I'm trying to extract the innertext of a selected dropdown item. The one I'm looking to return is "Institution 2"

<select name="ctl00$ContentPlaceHolder1$ddlInstName" id="ctl00_ContentPlaceHolder1_ddlInstName" style="background-color: rgb(255, 255, 128);">
        <option value="Select…">Select…</option>
        <option value="1867">Institution 1</option>
        <option selected="selected" value="719">Institution 2</option>
        <option value="1971">Institution 3</option>

This is what I have but it only returns a 0 value

account = IE.document.getElementById("ctl00_ContentPlaceHolder1_ddlInstName").getElementsByTagName("selected")(0).innerText

Any help would be greatly appreciated

QHarr · Accepted Answer · 2019-03-01 14:46:29Z

1

Use an attribute selector for selected. It is not a tag.

ie.document.querySelector("#ctl00_ContentPlaceHolder1_ddlInstName [selected]").innerText

answered Mar 1, 2019 at 14:46

QHarr

84.5k14 gold badges58 silver badges105 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

VBA Extract selected dropdown innertext from webpage

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related