Microsoft Office Forums - View Single Post - Get Zip code detail via JSON in VBA.

Thread: Get Zip code detail via JSON in VBA.

View Single Post

Old

12-18-2018, 03:08 AM

Mangesh1212 Mangesh1212 is offline

Mangesh1212 is offline

Mangesh1212 uses Windows 7 32bit

Windows 7 32bit Mangesh1212 uses Office 2007

Mangesh1212 uses Office 2007

Office 2007

Novice

The original poster

Join Date: Nov 2018

Posts: 8

Mangesh1212 is on a distinguished road

Default

Get Zip code detail via JSON in VBA.

Hello All,

I need to call JSON API in VBA which will set JSON values into the variables.

Requirement - I have zip codes which will pass with JSON API and receive Latitude and Longitude.
JSON API - https://api.zip-codes.com/ZipCodesAP...odeDetails/A0A 1E0?key=DEMOKEYVAL

Can anyone suggest me on call JSON API in VBA?

Many Thanks!

Reply With Quote