web query question

[TrippyTom]

Does anyone know where I can find a free web query that lets me look up zipcodes? I know there can be several zipcodes per city, but any one will do -- I don't do this often, but when I do, it's annoying having to look it up on usps.com and copy/pasting it into my Excel file.

 

[Norie]

Tom

What's the problem with using that site?

Couldn't you use it in a webquery and/or automate IE using VBA?

 

[TrippyTom]

Perhaps I don't understand how to setup the web query. I tried to follow the instructions in Excel help, but it didn't work with USPS.com. Also, it looks like USPS.com has a web query, but wants to charge for it. That's why I asked if there are free sites to do the same thing.

 

[Norie]

Tom

I've just looked at the site, and I can't see charges mentioned anywhere.

I'm assuming your using the Zip Code Lookup page accessed via the Find a Zip Code link.

 

[TrippyTom]

yes, and the "Search by City" tab (to be exact)
http://zip4.usps.com/zip4/citytown.jsp

 

[Norie]

Tom

Well I just tried that with ALBUQUERQUE, NM and I wasn't charged or asked to pay anything.

Note I mean I did it manually, not using Excel.

Oh, and I spelt ALBUQUERQUE wrong but it corrected it.

 

[TrippyTom]

Yes, I do it manually whenever I need to plot cities on maps, but how would you utilize this site in a web query in Excel so I don't have to copy/paste all the time?

 

[Norie]

Tom

Did you see where I mentioned automating IE?

 

[TrippyTom]

yes.... ?

I'm clueless what you're getting at, so I've decided to go another route. I was able to extract the zipcode info from my mapping program and convert it to a spreadsheet. I plan on using a vlookup with that data to make my life easier.