+ Reply to Thread
Results 1 to 3 of 3

importing city state and country from a ZIPTASTIC website

  1. #1
    Registered User
    Join Date
    06-18-2013
    Location
    canada
    MS-Off Ver
    Excel 365 (Mac)
    Posts
    26

    importing city state and country from a ZIPTASTIC website

    i want to be able to input a zipcode in a cell, and then have the city state and country be found from a website that is spitting out the data in text form in the window

    http://zip.elevenbasetwo.com/v2/US/90210

    check out what its spitting out please

    i need it to change the zipcode at the end of website automatically and grab the following data that spits out

    {"city": "Beverly Hills", "state": "California", "country": "US"}

    there is an example of my workbook attached, please review


    im open to other ideas as well
    Attached Files Attached Files

  2. #2
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,465

    Re: importing city state and country from a ZIPTASTIC website

    Are you trying to get a macro that enters the zip code from your workbook into the website, and then copies the output of the website back into the workbook?

  3. #3
    Registered User
    Join Date
    06-18-2013
    Location
    canada
    MS-Off Ver
    Excel 365 (Mac)
    Posts
    26

    Re: importing city state and country from a ZIPTASTIC website

    yes and copies the information it spits out in the main window
    wich is
    {"city": "Beverly Hills", "state": "California", "country": "US"}

    and i need the macro also to place this data neatly into the columns specified (city,state,country)\

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. I need Help to parse address city state zip and country if applicable for all fields
    By danpotash in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-01-2013, 03:16 PM
  2. Formaula to show specific State/City in a Country
    By Sarisha in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-16-2013, 12:01 PM
  3. Replies: 4
    Last Post: 04-04-2013, 03:44 PM
  4. State and country check macro
    By duugg in forum Excel Programming / VBA / Macros
    Replies: 37
    Last Post: 06-29-2009, 08:35 PM
  5. Macro Help:State/Country.
    By Philip White via OfficeKB.com in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-17-2005, 10:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1