Above my ability level :-( (JSON Parsing/ Editing with VBA)-- I have attached my attempt


New Member
Sep 7, 2018
Hello All! Hope you can help because I think I'm in on more than I can handle on this one.

I have linked 2 files. One is titled "xepg.json" and one titled "JSONCHANNELNUMBEREDIT.xlsm".

My goal is to get a json file imported to excel as a table (columns and rows) that can be easily edited and then somehow export the table back to a json file.

I have added the parser class to my file and also added the windows scripting reference. I have it working properly for a single item. However, my problem comes in that I have a json key (there are 21 or so total) that changes on every entry ("row"). I don't know how to deal with this and to be honest, the only reason I have gotten to where I am now is because I have found enough to copy paste everything I have together.-- I like excel but programming is not a forte of mine by any chance.

Is there anyone here that could help me get this thing working. I don't know how much time it would take, so if it would take alot of time I understand if no one if will to help me out a bit. I think the problem that is really messing me up is the fact that the first key changes every single row (new entry), this kind of makes it unusual for json I believe.

Thank you all for anything you can help me with!!Maybe there is a freeware tool out there that can do this and I can put excel down?? I couldn't find anything though.

Again, I have linked the 2 files below so that you can see what I have and what I'm trying to accomplish. Thank you all again!!


Forum statistics

Latest member

Some videos you may like

This Week's Hot Topics