excel VBA - Macro to click to the next page in IE -


i cannot figure out how click "next 100" button on page:

http://www.sec.gov/cgi-bin/browse-edgar?action=getcompany&cik=0000898293&type=&dateb=&owner=exclude&count=100

specifically section: 

<form>      <table border="0" width="100%">         <tbody><tr>            <td>items 1 - 100&nbsp;&nbsp;<a href="/cgi-bin/browse-edgar?action=getcompany&amp;cik=0000898293&amp;type=&amp;dateb=&amp;owner=exclude&amp;start=0&amp;count=100&amp;output=atom"><img src="/images/rss-feed-icon-14x14.png" alt="0000898293 filings" border="0" align="top"> rss feed</a></td>            <td style="text-align: right;"> <input type="button" value="next 100" onclick="parent.location='/cgi-bin/browse-edgar?action=getcompany&amp;cik=0000898293&amp;type=&amp;dateb=&amp;owner=exclude&amp;start=100&amp;count=100'"></td>         </tr>      </tbody></table>   </form>

below have tired in excel vba, don't have strong understanding of , know how click button if can see element id. 

sub dates()dim ie new internetexplorer ie.visible = true  ie.navigate "http://www.sec.gov/cgi-bin/browse-edgar?cik=jbl&owner=exclude&action=getcompany"  doevents loop until ie.readystate = readystate_complete dim doc htmldocument set doc = ie.document   doc.getelementbyid("count").value = 100 doc.forms.item(0).submit   dim objtag object each objtag in doc.getelementsbytagname(strtagname) if instr(objtag.outerhtml, "next 100") > 0      objtag.click     objtag.fireevent ("onclick")      exit  end if next

this should work you:

sub dates()     dim ie new internetexplorer      set ie = createobject("internetexplorer.application")      ie.visible = true     ie.navigate "http://www.sec.gov/cgi-bin/browse-edgar?action=getcompany&cik=0000898293&type=&dateb=&owner=exclude&count=100"              doevents     loop until ie.readystate = readystate_complete      ie.document         set elems = .getelementsbytagname("input")         each e in elems             if e.type = "button" , e.value = "next 100"                 e.click                 exit             end if         next e     end end sub

if using following link : 

http://www.sec.gov/cgi-bin/browse-edgar?cik=jbl&owner=exclude&action=getcompany

you'll have check for

if objcollection(i).type = "button" , objcollection(i).value = "next 40"

-

Popular posts from this blog

Apache NiFi ExecuteScript: Groovy script to replace Json values via a mapping file -

i working apache nifi 0.5.1 on groovy script replace incoming json values ones contained in mapping file. mapping file looks (it simple .txt): header1;header2;header3 a;some text;a2 i have started following: import groovy.json.jsonbuilder import groovy.json.jsonslurper import java.nio.charset.standardcharsets def flowfile = session.get(); if (flowfile == null) { return; } flowfile = session.write(flowfile, { inputstream, outputstream -> def content = """ { "field1": "a" "field2": "a", "field3": "a" }""" def slurped = new jsonslurper().parsetext(content) def builder = new jsonbuilder(slurped) builder.content.field1 = "a" builder.content.field2 = "some text" builder.content.field3 = "a2" outputstream.write(builder.toprettystring().ge...
Read more

node.js - How do I prevent MongoDB replica set from querying the primary? -

read-operations-only: is there way have mongodb replica set, make mongodb instance on box connected to, mongodb gets queried? i have 3 ec2 instances behind aws load balancer. on each ec2 instance runs mongodb, part of replica set. i have express endpoints on nodejs , connect replica set follows mongodb.mongoclient.connect('mongodb://1.1.1.1,2.2.2.2,3.3.3.3.', function (err, db) { if (err) { complete('{}'); } else { i distribute load of queries evenly across 3 instances of mongodb replica set instead of default having queries routed ec2 instance primary mongodb defined, because destroys point of load balancer (which balance load of queries across 3 instances evenly). my understanding when connecting mongodb replica set, primary instance selected unless primary instance down, , therefore purpose of every secondary instance serve backup. in example people call hot,cold,cold. because there 2...
Read more