Extracting value from JSON string in VBA

Asked May 16 '17 at 13:16

Active May 16 '17 at 13:26

Viewed 330 times

I need help on extracting value 102.498295 from JSON string in VBA. Thank you in advance.

{"success":true,"terms":"https:\/\/currencylayer.com\/terms","privacy":"https:\/\/currencylayer.com\/privacy","historical":true,"date":"2017-05-01","timestamp":1493683199,"source":"USD","quotes":{"USDNPR":102.498295}}

edited May 16 '17 at 13:26

Naktibalda

13,705
5
35
51

asked May 16 '17 at 13:16

shrestha

1

Possible duplicate of [Parsing JSON in Excel VBA](http://stackoverflow.com/questions/6627652/parsing-json-in-excel-vba) – CommonSense May 16 '17 at 13:36
Also: https://github.com/VBA-tools/VBA-JSON – CommonSense May 16 '17 at 13:37

Extracting value from JSON string in VBA

0 Answers0