IE 11 automation Select an item in the dropdown list

G

guyreys

New Member
Joined
Oct 26, 2016
Messages
2
Hey guy,

I am trying to perform some web scraping, but I cannot get the dropdown list filled. I already serached many websites and forums without any success.
In the code below I demonstrate some of the attempts that I have tried unsuccessfully, but doesn't mean that I ran the code that way.

I would apreciate any help, because I really need this code working, so please help me.

I am using Internet explorer 11

Thanks in advance

Here is my code

Sub test()
Dim appIE As Object
Dim oElement As Object
' open IE, navigate to the desired page and loop until fully loaded
Set appIE = CreateObject("InternetExplorer.Application")
my_url = "Giagro"
With appIE
.Visible = True
.navigate my_url
' .Top = 50
'.Left = 530
'.Height = 400
'.Width = 400
Do Until Not appIE.Busy And appIE.readyState = 4
DoEvents
Loop
End With

' Input the userid and password
appIE.document.getElementById("dsc_email").Value = "username"
appIE.document.getElementById("dsc_senha").Value = "password"
' Click the "Search" button
appIE.document.getElementById("btn_entrar").Click

Do Until Not appIE.Busy And appIE.readyState = 4
DoEvents
Loop


With appIE
.navigate ("Giagro")

Do Until Not appIE.Busy And appIE.readyState = 4
DoEvents
Loop
End With



'First Attempt
appIE.document.getElementById("ide_empresa").selectedIndex = 16

'Second Attempt
appIE.document.getElementById("ide_empresa").selectedIndex = 16
appIE.document.getElementById("ide_empresa").FireEvent ("onchange")

'Third Attempt
appIE.document.getElementById("ide_empresa").Focus
appIE.document.getElementById("ide_empresa").selectedIndex = 16
appIE.document.getElementById("ide_empresa").FireEvent ("onchange")

'Fouth Attempt
appIE.document.getElementsByTagName("ide_empresa") = "Basf"
appIE.document.getElementById("ide_empresa").FireEvent ("onchange")


' Submit
appIE.document.getElementById("submit_form").Click

End Sub
Code:

Here is the HTML
HTML:
<div class="form-group">
<select name="ide_empresa" tabindex="-1" class="form-control selectize-this reset-this selectized"
id="ide_empresa" style="display: none;" data-reset-to="0"><option selected="selected" value="1"></option></select>
<div class="selectize-control form-control selectize-this reset-this single">
<div class="selectize-input items has-options full has-items">
<div class="item" data-value="1">Action</div><input tabindex="-32768" style="left: -10000px; width: 4px; position: absolute; opacity: 0;" type="text" autocomplete="off"></div>
<div class="selectize-dropdown form-control selectize-this reset-this single" style="left: 0px; top: 34px;
width: 243px; display: none; visibility: visible;">
<div class="selectize-dropdown-content">
<div class="option" data-value="0" data-selectable="">Registrante</div>
<div class="option selected" data-value="1" data-selectable="">Action</div>
<div class="option" data-value="2" data-selectable="">Adama</div>
<div class="option" data-value="93" data-selectable="">ADM do Brasil</div>
<div class="option" data-value="94" data-selectable="">AEE</div>
<div class="option" data-value="96" data-selectable="">Agrária</div>
<div class="option" data-value="3" data-selectable="">Agrialliance</div>
<div class="option" data-value="102" data-selectable="">Agritec</div>
<div class="option" data-value="109" data-selectable="">Agrocete</div>
<div class="option" data-value="4" data-selectable="">Agroimport</div>
<div class="option" data-value="113" data-selectable="">Agroli</div>
<div class="option" data-value="115" data-selectable="">Agrovant</div>
<div class="option" data-value="116" data-selectable="">Akzo</div>
<div class="option" data-value="5" data-selectable="">Alamos</div>
<div class="option" data-value="6" data-selectable="">Allierbrasil</div>
<div class="option" data-value="7" data-selectable="">Alta</div>
<div class="option" data-value="8" data-selectable="">Ameribrás</div>
<div class="option" data-value="9" data-selectable="">AMVAC</div>
<div class="option" data-value="10" data-selectable="">ANASAC</div>
<div class="option" data-value="123" data-selectable="">Andermatt</div>
<div class="option" data-value="124" data-selectable="">Anésia Mendes</div>
<div class="option" data-value="11" data-selectable="">Arysta</div>
<div class="option" data-value="129" data-selectable="">ASPLAN</div>
<div class="option" data-value="12" data-selectable="">Atanor</div>
<div class="option" data-value="13" data-selectable="">Atar</div>
<div class="option" data-value="434" data-selectable="">Athena Brasil</div>
<div class="option" data-value="14" data-selectable="">Atta Kill</div>
<div class="option" data-value="132" data-selectable="">Auca</div>
<div class="option" data-value="15" data-selectable="">Avgust</div>
<div class="option" data-value="135" data-selectable="">Ballagro</div>
<div class="option" data-value="16" data-selectable="">Basf</div>
<div class="option" data-value="17" data-selectable="">Bayer</div>
<div class="option" data-value="139" data-selectable="">Bernardo Química</div>
<div class="option" data-value="140" data-selectable="">Bio Controle</div>
<div class="option" data-value="19" data-selectable="">Bio Soja</div>
<div class="option" data-value="142" data-selectable="">Biocontrol</div>
<div class="option" data-value="429" data-selectable="">Biodefense</div>
<div class="option" data-value="143" data-selectable="">Bioeco</div>
<div class="option" data-value="144" data-selectable="">Bioeffect</div>
<div class="option" data-value="145" data-selectable="">Bioenergia</div>
<div class="option" data-value="147" data-selectable="">Biofungi</div>
<div class="option" data-value="148" data-selectable="">Biomoscamed</div>
<div class="option" data-value="150" data-selectable="">Biopremium</div>
<div class="option" data-value="151" data-selectable="">BioResult</div>
<div class="option" data-value="152" data-selectable="">BIOSPHERE</div>
<div class="option" data-value="154" data-selectable="">Biotech</div>
<div class="option" data-value="426" data-selectable="">Biovalens</div>
<div class="option" data-value="155" data-selectable="">Bosquiroli</div>
</div>
</div>
</div>
</div>
HTML:
 

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).
Sort by date Sort by votes
HTML

<div class="form-group">
<select name="ide_empresa" tabindex="-1" class="form-control selectize-this reset-this selectized"
id="ide_empresa" style="display: none;" data-reset-to="0"><option selected="selected" value="1"></option></select>
<div class="selectize-control form-control selectize-this reset-this single">
<div class="selectize-input items has-options full has-items">
<div class="item" data-value="1">Action</div><input tabindex="-32768" style="left: -10000px; width: 4px; position: absolute; opacity: 0;" type="text" autocomplete="off"></div>
<div class="selectize-dropdown form-control selectize-this reset-this single" style="left: 0px; top: 34px;
width: 243px; display: none; visibility: visible;">
<div class="selectize-dropdown-content">
<div class="option" data-value="0" data-selectable="">Registrante</div>
<div class="option selected" data-value="1" data-selectable="">Action</div>
<div class="option" data-value="2" data-selectable="">Adama</div>
<div class="option" data-value="93" data-selectable="">ADM do Brasil</div>
<div class="option" data-value="94" data-selectable="">AEE</div>
<div class="option" data-value="96" data-selectable="">Agrária</div>
<div class="option" data-value="3" data-selectable="">Agrialliance</div>
<div class="option" data-value="102" data-selectable="">Agritec</div>
<div class="option" data-value="109" data-selectable="">Agrocete</div>
<div class="option" data-value="4" data-selectable="">Agroimport</div>
<div class="option" data-value="113" data-selectable="">Agroli</div>
<div class="option" data-value="115" data-selectable="">Agrovant</div>
<div class="option" data-value="116" data-selectable="">Akzo</div>
<div class="option" data-value="5" data-selectable="">Alamos</div>
<div class="option" data-value="6" data-selectable="">Allierbrasil</div>
<div class="option" data-value="7" data-selectable="">Alta</div>
<div class="option" data-value="8" data-selectable="">Ameribrás</div>
<div class="option" data-value="9" data-selectable="">AMVAC</div>
<div class="option" data-value="10" data-selectable="">ANASAC</div>
<div class="option" data-value="123" data-selectable="">Andermatt</div>
<div class="option" data-value="124" data-selectable="">Anésia Mendes</div>
<div class="option" data-value="11" data-selectable="">Arysta</div>
<div class="option" data-value="129" data-selectable="">ASPLAN</div>
<div class="option" data-value="12" data-selectable="">Atanor</div>
<div class="option" data-value="13" data-selectable="">Atar</div>
<div class="option" data-value="434" data-selectable="">Athena Brasil</div>
<div class="option" data-value="14" data-selectable="">Atta Kill</div>
<div class="option" data-value="132" data-selectable="">Auca</div>
<div class="option" data-value="15" data-selectable="">Avgust</div>
<div class="option" data-value="135" data-selectable="">Ballagro</div>
<div class="option" data-value="16" data-selectable="">Basf</div>
<div class="option" data-value="17" data-selectable="">Bayer</div>
<div class="option" data-value="139" data-selectable="">Bernardo Química</div>
<div class="option" data-value="140" data-selectable="">Bio Controle</div>
<div class="option" data-value="19" data-selectable="">Bio Soja</div>
<div class="option" data-value="142" data-selectable="">Biocontrol</div>
<div class="option" data-value="429" data-selectable="">Biodefense</div>
<div class="option" data-value="143" data-selectable="">Bioeco</div>
<div class="option" data-value="144" data-selectable="">Bioeffect</div>
<div class="option" data-value="145" data-selectable="">Bioenergia</div>
<div class="option" data-value="147" data-selectable="">Biofungi</div>


Registrante

Action

Adama

ADM do Brasil

AEE

Agrária

Agrialliance

Agritec

Agrocete

Agroimport

Agroli

Agrovant

Akzo

Alamos

Allierbrasil

Alta

Ameribrás

AMVAC

ANASAC

Andermatt

Anésia Mendes

Arysta

ASPLAN

Atanor

Atar

Athena Brasil

Atta Kill

Auca

Avgust

Ballagro

Basf

Bayer

Bernardo Química

Bio Controle

Bio Soja

Biocontrol

Biodefense

Bioeco

Bioeffect

Bioenergia

Biofungi

Biomoscamed

Biopremium

BioResult

BIOSPHERE

Biotech

Biovalens

Bosquiroli




</div>
</div>
</div>
</div>





[/QUOTE]
 
Upvote 0
Hi, do you get solution for this. Am also looking for the solution. Kindly share the solution.
 
Upvote 0
You must log in or register to reply here.

Similar threads

J
  • Solved
VBA Web Scraping - FindElementBy - DownloadCSV Button ElementNotVisibleError Runtime error 11
2
Replies
15
Views
2K
johnd3099
J
B
  • Question
VBA Selenium How select an option from dropdown list witthout select?
Replies
1
Views
775
bionic
B
G
  • Question
Get value from web document (intranet) input element with VBA
2
Replies
18
Views
900
Gregor_1
G
C
  • Question
VBA Web Select DropDown
Replies
0
Views
699
congresojr5
C
A
  • Question
Web Scraping using VBA
Replies
4
Views
9K
atr140
A

Forum statistics

Threads
1,214,927
Messages
6,122,309
Members
449,080
Latest member
jmsotelo

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top