Save Excel Table to a JSON File with Simple VBA Macro

[@deeperblue77]

Thanks! Exactly what I needed! 😃

[@mafnomekanix5442]

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

[@archanaghodeswar8130]

Thanks. This code worked for me.

[@ameyavarma8568]

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

[@MelissaPortales]

Great tutorial, thanks!

[@Pseudo___]

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

[@valkingelf]

Thank you, It helps me a lot!

[@jonusdarr2443]

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

[@andrewcosgrove6447]

I got a "run time error '9': subscript out of range" error on this line: "For Each c In ActiveSheet.ListObjects(1).HeaderRowRange.Cells" any idea why?

[@na-ql3sm]

Did you ever figure this out? I am getting the same error.

[@eToolGuy]

@@na-ql3sm Your grid data needs to be defined as an Excel Table. Select the data you want to convert, then Go to then on the Ribbon and select a style.

[@victorrichtmann3590]

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?

[@jonusdarr2443]

Did you solve this? Thanks

[@mattkolberg2409]

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.

[@fortunesipay149]

I came to the comment to say the exact same thing.

[@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.

[@vidhijindal21]

Did you achieve that? I am looking for the same.

[@secretstorymusic]

@@vidhijindal21 Not yet. I'm considering loading my data into SAS and automating a macro to save as different files. Will LYK if that works.

[@michaelboggs438]

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.

[@edderantonioparranaranjo4919]

It helped me a lot, thank you

[@jakebrett3754]

Dont know if you guys gives a shit but if you're bored like me atm you can stream all the new series on instaflixxer. Been watching with my gf for the last weeks :)

[@kadenmekhi4737]

@Jake Brett Yup, have been using instaflixxer for since december myself :)

[@patrickdanielmanalo3502]

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

[@patrickdanielmanalo3502]

@user-rg4ze1uj7d any ideas?

[@vsChris]

I'm getting the same error. Were you ever able to figure this out?

[@alejandroarmagedon8095]

ya te solucionarion?

[@phaneeshanagraj9232]

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

[@blankcheckguy69]

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.

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

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

[@crocodilearms2093]

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\""}

[@basasasas1]

you found a solution?

[@crocodilearms2093]

@@basasasas1 I did. Not an elegant one!

[@kanishksharma9828]

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

[@na-ql3sm]

did you figure it out?

[@kanishksharma9828]

@@na-ql3sm no not yet

[@DepechLyot]

it adds -- Private Sub CommandButton1_Click() extra End Sub need delete them

[@sheheryarsarwar5140]

You need to check might be your design mode is on under development.

[@DepechLyot]

@@sheheryarsarwar5140 no, he said can click it.

[@alejandroarmagedon8095]

help!! ERROR 424

[@Happy-cz8ft]

Only shows you that you need to download an function.

[@sumthinsbrewin]

Your constant slurping is rather annoying.

[@johankneijber]

Completely agree. Otherwise very good.

[@paddy1813]

I was surprised how often someone has to drink during a video recording...

[@rogerdoger303]

Is that coffee you're drinking? 🙂

[@mohamad.Khaled]

thx

[@serhiirumiantsev7736]

Script is not working, it shows error

[@na-ql3sm]

did you figure it out?

[@eimhalim9796]

oh my god.. i found it quite distracting when u keep sipping whatever that is you're drinking.

[@1982dhanu]

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 ActiveSheet.ListObject(1).HeaderRowRange.Cells'