How To Parse JSON With Excel VBA

I didn’t come up with this code, but it is pretty cool.

It shows how to parse a JSON string with VBA.

The impetus for this was to access the price data for various coins on

…and to get the price data for 50+ coins required getting a coinmarketcap api, and resulted in a JSON string.

I just included the essential stuff below, maybe it will help you out too.

Go here for more information:

Go to this post to see the post for the Load Text File:

Here is a bit of the input file and the same bit when run through the parser:

Please remember to subscribe to my youtube channel

Been helped? Get these!