internet explorer - Importing/scraping an website into excel -
i trying scrape data database, , have pretty set. in ie tab has me logged in database, , paste query link there through vba. how extract data returns ie tab , put excel cell or array. this code have opening query: sub import() dim row integer dim strtargetfile string dim wb workbook dim test string dim ie object call fill_array_cultivar row = 3 4 sheets.add.name = cultivar_array(row, 1) strtargetfile = "https://www3.wipo.int/pluto/user/jsp/select.jsp?fl=app_date%2cden_info%2cden_final&hl=false&json.nl=map&wt=json&type=upov&start=0&qi=3-nncxq6etevv184o9nnd5yg%3d%3d&q=cc%3ait%20and%20latin_name%3a(zea%20mays)%20and%20den_info%3a" & trim(cultivar_array(row, 1)) & "&facet=false" set ie = getie("https://www3.wipo.int" & "*") if not ie nothing ie.navigate (strtargetfile) else msgbox "ie not found!" end if next row end sub and appropriate fu...