Need help with IE selecting drop down

[BHo15]

I am trying to select from a dropdown in IE from Access VBA. You cannot right click on the dropdown and inspect element. I ended up using something on found online, and it worked for a while, but it has now stopped working. Here is what I was using...

IEWindow.Document.querySelector("div[id=pagecontents] div[class=container] div[id=resultOptions] form[name=resultOptions] select[id=selectResult]").Focus
IEWindow.Document.querySelector("div[id=pagecontents] div[class=container] div[id=resultOptions] form[name=resultOptions] select[id=selectResult]").selectedIndex = 4
IEWindow.Document.querySelector("div[id=pagecontents] div[class=container] div[id=resultOptions] form[name=resultOptions] select[id=selectResult]").dispatchEvent evt

If I remember correctly, the error that occured is that it could not find the object (presumably the IE control that is referenced).

I then found another way to find that dropdown, and it appears that it is a control called selectResult (see the HTML below).

<div id="page-header">_</div>
<!-- end of PAGE HEADER -->
<-- PAGE CONTENTS -->
<div id="pagecontents">
   <div class="container">
       <div class="panel panel-default scc-scanengine-panel" id="scc-scanengine-criteria">_</div>
       <div id="resultOptions">
          <form name="resultOptions">
             <span class="form-item-label">Available Actions</span>
             <select id="selectResult">
                <option selected="selected" value="none">- Choose -</option>
                <option value="new">Store these results in a new C_</option>
                <option value="merge">Merge these results with an ex_</option>
                <option value="replace">Replace an existing ChartList _</option>
                <option value="csv">Download In CSV Format</option>
             </select>
          </form>
        </div>
        <script type = "text/javascript">,!-- var sortOrder = "USAD"; _</script>
        <form name="submitForm" action="/def/servlet/SC.uscan" method="post">_</form>
<!-- TABLE DATE ROW -->
<div class="dt-date-row">_</div>
</div>

For those that are good at HTML... Please don't shoot me. I had a screen print of the HTML, and then I tried to type it out.

So... The problem is that I am having trouble connecting to the IE control (the dropdown box). Then, when I connect to it, I need to be able to select the csv option (which I'm assuming is option 4 if zero based).

Thoughts?

[BHo15]

I lot of views on this? Anyone able to help?

[NeoPa]

Unlikely I would expect. The numbers of Access programmers who have experience controlling IE from VBA is probably very small relatively. I'm only surprised you seem to expect otherwise.

Good luck and all, but I can't hold out a great deal of hope in the circumstances.

[BHo15]

Oh well. It was a good thought.

[NeoPa]

Never hurts to try. Just bear in mind this is an Access forum so is likely to have mainly Access people reviewing it.

It's not impossible that some might have the experience you need but it's necessarily going to be a small fraction of those here.

[BHo15]

I’ve been working in Access for about 15 years, and though it’s rare, I have had need to write VBA FOR IE, so I was just hoping that others did as well. Bytes is my favorite message board for Access and VBA. So I always like to start here.

[NeoPa]

Makes good sense. Just don't be too disappointed when you find you're now that expert ;-)

[Rabbit]

Seeing as how you there's an id, you can use the more straightforward getElementById() function instead of querySelector().

[BHo15]

Yes sir, I tried that, and it is still not connecting correctly. It keeps saying "object required".

[Rabbit]

Try running Access as an admin. I've noticed that trying to script IE will tend to disconnect from the object unless I'm running the script as admin

[BHo15]

Interesting Rabbit. I never would have guessed that. I'll give it a go.