trying to extract the address suggestions (when you enter a wrong address) from this web site
https://www.nzpost.co.nz/tools/address-postcode-finder
using selenium I clicked on it and the python code (selenium doesn't do vba) it gave was
I AM juSt not sure how to do this in vba.self.driver.find_element(By.CSS_SELECTOR, ".jss5").click() self.driver.find_element(By.CSS_SELECTOR, ".app-layout__main-left").click()
After that I can pull it in vba with
so no problem as long as I can get past the little hurdle.ie.document.all.searchdata.Value
Bookmarks