How to parse JSON with VBA-JSON

Parse JSON in VBA with VBA-JSON parser! A step by step tutorial to read and access each JSON data element in Excel VBA

[UPBear]

Fantastic tutorial. Simple, robust code and solved what I needed with a few lines. I was tired of testing giant codes that weren't working. Thank you very much from Brazil!

[danm]

Thanks Red Stapler! Working on a legacy application at work, written in VB6, and this made my life way easier!!

[KabilPrograma]

Wonderful, I've to parse information of more than 10, 000 objects to send them to a DB Table. This saved my life

[BorisKaran]

Dear Red, you are a lifesaver. I almost threw my towel in the corner. Deep respect and thank you.

[johnhschuster]

Most Just saved me hours of time. Also, liked your method used in the video

[brian]

I love your video man. i can't thank you enought to how you have saved me.

[mclean]

This is how a tutorial should be done! Thanks!

[stevenshi]

Very practical, I did not look at the video, I researched it myself, and watching the video early can save a lot of time.

[thecreamman]

Loved it! Exactly what I needed to know to get off the ground with this project :)

[descomplicacomunicacao]

after all this years still working. thanks

[factsanddatadriven]

Thank you very much for the video on VBA-Jason

[aescuder]

Muchísimas gracias por su explicación !!, me ha sido de muchísima utilidad !!

[thenotoriousDFL]

After Hours of sitting through annoying unhelpful tutorials, this was the tutorial that sparked my breakthrough. Well done, thank you. Liked and subbed.

[axelbender]

ohhh it's been so long pseudo-parsing JSON in VBA by hacking { } and [ ] characters... now I can start to think of myself as a programmer rather than a code beggar... thanks so much buddy

[L.Medrano]

Grate contribution mate, it helped me like a lot

[ShivanandanaHegde]

Awesome! Love the video. You saved ton of my time. Thank you!! BTW, What is the background music?

[mjohnstone]

Hi just looking into the VBA-JSON parser in particular why it requires the Windows Time Zone Information API calls. From a quick look that would suggest any date-time data obtained is converted according to the local PC settings. That might have issues if the date/time obtained isn't from the same time zone.

[absel]

What if you want to know the lenght of an array inside the JSON parameters?

[bernhardniklas]

Nice function. Is there a possibility to count the entry in on level? I have a dynamic datasets in on level of data.

[PeterEastvold]

Is there something that will act the same for XML? Seems the XML parsers I find want me to setup an object class before-hand, but I need something dynamic like this!