Pull USPS address to excel

Hi Experts,

I'm looking for your help to get the address from USPS.com. I have about 3,000 addresses in Excel I'd like to verify.

So I am looking for VBA code to open the USPS site and enter the the data and retrieve the correct address.


validate in columns (all in A-E). Code below runs through rows that you specify (see For r = xxx to xxx) returns the validated address (if found) back to columns (G-K).

Except they updated the site and I'm struggling. (please forgive me, as I'm extremely novice)
Can update R value.
Don't need state since it's a dropdown now. (would just need to enter street address & zip - click find)

this is tough. this is what is classified as API work. although the technique is technically not called an API. more than likely no-one here will write the solution without being paid. However, you need to start with all of the following resources, because microsoft has not provided a VBA library that can use its Edge browser just yet. and they probably won't either, cuz VBA 40 years old and they're trying deperately to push the world into the new age of edge and all of it's ""wonderful super duper features"". =(

https://docs.microsoft.com/en-us/off...rary-reference

https://docs.microsoft.com/en-us/pre...8(v=office.11)

written by me many moons ago:
https://www.access-programmers.co.uk...ng-vba.176968/

https://docs.microsoft.com/en-us/off...plication.wait

https://docs.microsoft.com/en-us/pre...52052(v=vs.85)

you also need to read about the DOM: https://www.google.com/search?q=docu...odel+w3schools