Using below code I am able to get the value from a drop down which is disabled. But I want to get a selected value from drop down which is still enabled..
Set drp = IE.Document.getElementById("ctl00_Content_ddlWorkNature") Sheet1.Cells(5, 5) = drp.Item(drp.selectedIndex).innerText
In the below piece of code Nature of work is a drop down with following options: 1. Development 2. Production Support 3. Projection Coordination 4. Project Management 5. Testing
Select Development Production Support Project Coordination Project Management Testing Please select Nature of Work