i have intranet based website @ work i'd input sku's , scrape data comes excel sheet using vba , ie8. waiting on access license approvals , approval gain access our ibm as400 server. ie8 not support getelementsbyname, , search bar has no id, of examples i've found online aren't relevant.
sub scraper() dim item long item = "10011" 'this placed in loop multiple searches set objie = createobject("internetexplorer.application") objie.visible = true ' navigate , download web page objie.navigate "http://**********.aspx" while objie.readystate <> 4 or objie.busy doevents loop objie.document.getelementsbyname("input").value = item end sub
here's photo of inspected element tree. can see, there name (input) , class (st1), no id. how can search data input area? stuck ie8, although have access chrome well...
Comments
Post a Comment