+ Reply to Thread
Results 1 to 3 of 3

VBA and API to Pull Data

  1. #1
    Registered User
    Join Date
    11-18-2016
    Location
    Seattle, Washington
    MS-Off Ver
    2013
    Posts
    60

    VBA and API to Pull Data

    Hi,

    I'd like to pull the county code from this url:

    https://geocoding.geo.census.gov/geo...14&format=json

    Using vba/api.

    Here's what I have, but I need to figure out how to get a response text

    Please Login or Register  to view this content.
    Here's a link to the website API information:

    https://geocoding.geo.census.gov/geo...vices_API.html

    And help would be greatly appreciated. Thank you!

  2. #2
    Forum Contributor kalbasiatka's Avatar
    Join Date
    02-27-2016
    Location
    Brest, Belarus
    MS-Off Ver
    2021
    Posts
    224

    Re: VBA and API to Pull Data

    Please Login or Register  to view this content.
    To do it for me and help me it is 2 different things!
    Sorry for my english, blame Google translator

  3. #3
    Forum Expert JasperD's Avatar
    Join Date
    05-07-2013
    Location
    Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    1,393

    Re: VBA and API to Pull Data

    Try this:

    Please Login or Register  to view this content.
    Please click the * below if this helps

+ 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. Replies: 0
    Last Post: 07-08-2015, 06:31 AM
  2. Pull Data from Sheet Based on Criteria -- Populate UserForm & ask for Missing Data
    By roxybethany in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-15-2014, 12:08 PM
  3. Pull Data from Sheet Based on Criteria -- Populate UserForm & ask for Missing Data
    By roxybethany in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-08-2014, 02:05 PM
  4. Need to pull data from closed file, sort, and send the data to specific sheets.
    By ghostman73 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-05-2013, 05:13 PM
  5. help on vba code to pull data with conditions ,filename,avoid header,unfiltered data
    By breadwinner in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-27-2013, 05:57 AM
  6. Pull Data from Multiple Columns Based On Data Validation List Selection
    By CHRISOK in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-13-2013, 11:41 PM
  7. Use of Excel to pull data from database daily, posting new data below older data
    By Ishness in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-09-2011, 10:08 AM

Tags for this Thread

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