Which 'reference' allows Json in VBA

Question

Now, I am trying to use JSON in VBA. Which Reference should be used in VBA to allow Json objects, cJobjects?

I have tried to declare as follow:

Dim myObj As cJobject

But can't get compiler to recognize cJobject.

its EXCEL-VBA btw, and I have already tried "Microsoft ActiveX Data Objects 2.8" — Nachiket Katore, Aug 03 '15 at 07:56

score 0 · Answer 1 · edited May 23 '17 at 11:58

0

Actually, cJobject is a custom class module. So, you need to all related class module for using this. Actually, It has other way to parse JSON in vba. I suggested to use that way like this.

Here is reference for using cJobject.

Download, cDataSet.xls and check it. This will be helpful for you.

edited May 23 '17 at 11:58

Community

1
1

answered Aug 03 '15 at 09:26

R.Katnaan

2,486
4
24
36

Thanks @Nicolas, will try it and let you know – Nachiket Katore Aug 03 '15 at 11:48
My worry is why I have to include so many classes? Cant it be added as a "eference"? Just a tick mark in reference and tada... we got JSON object. – Nachiket Katore Aug 04 '15 at 05:22
I don't know, I am not familiar with this one. Just search on Internet for helping you, and parsing my search result. – R.Katnaan Aug 04 '15 at 05:26

Which 'reference' allows Json in VBA

1 Answers1