Thread: How can I get a postal code in a cell - from the internet?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student
 
Posts: n/a
Default How can I get a postal code in a cell - from the internet?
Open:

http://zip4.usps.com/zip4/welcome.jsp

and enter the address information via VBA. The web page will return the 5+4
ZIP code which can then download.
--
Gary's Student


"DeanWHandy" wrote:

I'm trying to insert a postal code into a spreadsheet based on the address
information we are given. I need a way to use the street address, city and
state to plug into a message to a lookup table on the internet so that I can
get the ZIP code back to insert into the correct cell on the spreadsheet.
Reply With QuoteReply With Quote