Save Excel Table to a JSON File with Simple VBA Macro

In this video, I teach you to create a simple VBA macro to save an Excel table to a JSON file. The macro uses VBA-JSON to convert between a VBA Collection or Dictionary to a JSON file.

[mafnomekanix]

I found this in 2023. Good job dude. I love this

[Pseudo___]

Okay but what if I got multiple arrays in multiple objects with properties sporadically throughtout, ?

[ameyavarma]

Your a life saver! Thanks for doing my job for me:)

[victorrichtmann]

The tutorial is very good. This worked well for me.
But it doesn't work with a special character. Do you have any idea how to adjust as a special character?

[andrewcosgrove]

I got a "run time error '9': subscript out of range" error on this line: "For Each c In any idea why?

[michaelboggs]

Is it possible to modify this so that the only outputs are strings? I'm trying to get data to upload into Cosmos DB for Azure, and Azure really likes string data inputs.

[dhanu]

Hi, Found this very useful
But I get this Run time error '438' at line, I guess HeaderRowRange has to be used by a fixed length now.
Are you planning to change your code ?.
'For Each c In

[jonusdarr]

I'm a nub and I got this. Thanks a lot.

[phaneeshanagraj]

How to add data from multiple workbook and convert into JSON format

[secretstorymusic]

It would be great to know how to store individual lines as separate files as my log only allows single line files to be read.

[jmula]

is there a simple line of code I can add that allows the converter to skip a column if there is no value attatched in the table (ie. left blank) ?

trying to format metadata for a large-scale NFT project (non-generative/where the art was done by hand) and we don’t need any extraneous properties as they literally should not exist if the piece of art does not call for it.

[ВладимирГригин-по]

Hi! How to save JSON in format UTF-8? Tnx!

[mattkolberg]

This is really good. Just some constructive criticism. Speaking live, or narrating in a video, you want to avoid doing things that distract the listener. For you, it's taking a sip of whatever it is you're drinking. It happens very often. You'll be a better speaker if you avoid that.

[patrickdanielmanalo]

I got a "Run time error '424' Object Required" on this line "Print #fileNumber, JsonCoverter.ConvertToJson(collectionToJson, Whitespace:=2)" any idea why?

[crocodilearms]

How do you build a complex table and export to nested json?

{"id":"0", "attributes":[{"name":"one", "value":"1"}, {"name":"two", "value":"2"}], "description":"The \"description\""}

[rogerdoger]

Is that coffee you're drinking? 🙂

[andyschrock]

Your constant slurping is rather annoying.

[kanishksharma]

My Button is not working, I can click it but it is not working! :(

[serhiirumiantsev]

Script is not working, it shows error